Pages

▼
Wednesday, August 25, 2010

How to edit Linked Objects using Word VBA

›
How to open and edit Linked Excel files from Word using VBA One can insert an object in word by either linking or embedding. We have alrea...
1 comment:
Saturday, August 21, 2010

Hide Sheet Tabs using VBA / Hide Excel Sheet Tabs (2007/2010)

›
How to Hide Excel Sheet Names using VBA If you want to hide the Sheet Tab (as shown below) you can do that using Excel Options Hide / Un...
5 comments:
Friday, August 06, 2010

How to Read Excel Sheet embedded in Word Document using VBA

›
How to edit Embedded Objects (Excel Workbook) using Word VBA In our previous posts we have seen how to Embedd an Word Document in Excel Ob...
9 comments:

How to Extract All Formula's in Excel Sheet using VBA

›
Highlight all cells containing Formulas using Excel VBA The following snippet highlights all cells that contain formula Sub HighLight_Fo...
1 comment:
Wednesday, August 04, 2010

How to Connect XLSX file (Excel Workbook) through ADO

›
Using Excel (Xlsx) file as a database using VBA (ActiveX Data Objects - ADO) In the past we have already seen how to Connect to an Excel f...
2 comments:
Tuesday, July 27, 2010

Excel VBA Autofilter - Specify Multiple Criteria using Array

›
How to pass an Array as Criteria in Excel Autofilter - VBA After long time let us revisit our good old Autofilter Fruits example . The fol...
9 comments:
Sunday, July 25, 2010

Program/Macro to Highlight Editable Ranges in Protected Sheet

›
How to identify Editable ranges in a protected Excel sheet using VBA My good friend Srikanth Srinivasan is a Project Manager whom Microsoft...
1 comment:
Friday, July 23, 2010

How to retrieve value from Content Controls using Word VBA

›
The following snippet validates the user selection using VBA. This code uses the content control created in previous example - ( How to add ...
3 comments:
Thursday, July 22, 2010

How to add Content Controls using VBA

›
Add Combobox to Word document using VBA The following code would add a Combo Box control to the existing Word document: Sub Add_A_Content...
2 comments:
Monday, July 05, 2010

GetObject Error with Internet Explorer

›
How to get active Internet Explorer Object using Getobject in VBA Set IEBrowser = GetObject(, "InternetExplorer.Application") U...
Friday, July 02, 2010

How to extract file name from FullPath string using VBA

›
Extract Name of the File from Path / Fullname using VBA There are many methods to extract the filename from a given string. You can use Fi...
9 comments:
Thursday, June 24, 2010

How to simulate speech Echo in VBA

›
The following snippet simulates ( a sort of ) the Echo effect in VBA. This uses Microsoft Speech Object Library Sub Voice_It_Out() Dim...

VBA : How to convert text file to speech (audio) using VBA

›
Text to Speech using Excel VBA : Audio/Speech from input file If you want to spell out the content of text file using VBA you can do it as...
5 comments:

How to get Author details from Track Changes using VBA

›
Word VBA - extract Revision Author information If you want to know the details of track revisions, for example, Author name etc the followi...
2 comments:
Sunday, June 13, 2010

How to Save Excel Range as Image using VBA

›
How to copy Excel Range as Image using VBA / How to export Excel Range as Imag e The following code saves the Excel Range (A1:B2) as an ima...
16 comments:
Thursday, May 27, 2010

How to Compress Pictures in Excel using VBA

›
How to Programatically Compress Pictures/Images in Excel using VBA If you are trying to compress pictures, you will normally be doing using...
2 comments:

How to add description to Macro Functions in Excel VBA

›
How to add argument description to Macros/User Defined Functions in Excel VBA User-defined functions are created in Excel for helping the ...

How to Extract TextBox Contents from All Slides using Powerpoint VBA

›
Extract Text from Textboxes in Powerpoint slides using VBA Dedicated to good blogger friend Rahul. This code snippet loops through the slid...
5 comments:
Wednesday, May 26, 2010

How to get OS Version using VBA

›
How to retrieve Operating System Information using Excel/Word VBA The version information of OS can be retrieved using the WIN API function...
5 comments:
Saturday, May 22, 2010

How to iterate through all Subdirectories till the last directory in VBA

›
List all Level SubDirectories using VBA The following code lists all the directories under c:\Temp Function GetSubDir(ByVal sDir) D...
4 comments: