Pages

▼
Monday, June 30, 2008

Extract Error Cells in a Sheet using Excel VBA

›
Identify Error Cells in a Sheet using Excel VBA The following code can be used to identify cells that contains error because of some formula...
2 comments:

Extract Cells containing Numeric Formula Result

›
Identify cells containing numeric result of a formula Sub Rows_Wt_Number_Formula() Dim oNOCells On Error GoTo Err_Hdlr Set oNOCells = Range(...

Extract Cells Containing Numbers alone using Excel VBA

›
Identify cells with Numerals/Numbers using Excel VBA Many times some text values create problem for which should be a numeric column. In th...

Search and Open Files using Excel VBA (FileSearch)

›
Sort Files By Date using Excel VBA File Search Use the FileSearch property to return the FileSearch object. The following example searches...
11 comments:

Check Presence of Comboboxes in Excel Sheet using Excel VBA

›
Programatically Check Dropdowns in Excel Sheet using VBA The following code will help to check the presence of combo boxes on Excel sheet Su...
Sunday, June 01, 2008

Check if Code is Trusted Outlook VBA

›
Check if Code is Trusted Outlook VBA Function IsCodeTrusted() As Boolean IsCodeTrusted = Application.IsTrusted End Function For out-of-pr...

Explorers Collection in Outlook

›
The Explorers collection contains views of all open folders. Each open folder view is an Explorer object and has a CurrentFolder object...
Sunday, May 25, 2008

Google Search Using VBA

›
Search Webpages using VBA / Search Text in Google using Excel VBA / Programmaticaly search text in Google This code requires Microsoft Inter...
3 comments:

Excel VBA - 1004 -- The file could not be accessed

›
Solution for 1004 -- The file could not be accessed while saving the File 1004 Microsoft Office Excel cannot access the file 'C:\temp...
Saturday, May 10, 2008

Using Excel as Database using VBA (Excel ADO)

›
VBA ADO Code for using Excel as Database Though many database systems have come , still there is a need to use Excel as Backend database. Th...
12 comments:
Tuesday, May 06, 2008

Create Additional Pivot Table using Excel VBA (from Existing PivotCache)

›
Macro to Create a Pivot Table from Existing Pivot Cache Many times you wi ll ha ve a Pivot Table created from a pivot cache and you have a ...
4 comments:

Create Pivot Table using Excel VBA

›
Macro to Create a Pivot Table from New Pivot Cache Sub Create_Pivot_Table_From_Cache() Dim oPC As PivotCache Dim oPT As PivotTable Dim ...
4 comments:

Create Pivot Table from VBA using Wizard

›
Use PivotTable Wizard Programmatically using Excel VBA You can use PivotTableWizard method of Worksheet object to create a new PivotTable ...
1 comment:

Creating a Command Button on Sheet using Excel VBA

›
Adding an OLE Object (Command Button) to a Worksheet using Excel VBA Sub Create_Command_Button_2007() ' ' Creat...
13 comments:
Sunday, April 27, 2008

Document Variables in Outlook using VBA

›
Add Hidden Data using StorageItem in Outlook VBA There are multiple ways to have a template in Outlook for achieving tasks. Sometimes, you ...
2 comments:

How to use .Net Array.Sort Function in VBA

›
Using Vb.Net Function in VBA How to use a VB.Net DLL/T LB in Excel VBA Here is an example for using the customized .NET Function in Excel V...
2 comments:
Thursday, April 17, 2008

Creating Digital Signature for VBA Project (Outlook VBA / Excel VBA/ Word VBA)

›
How to digitally sign a VBA Project To create a code-signing certificate, follow these steps: From Programs menu, choose Microsoft Office -...
6 comments: