Pages

▼
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:

How to retrieve images of the Word document using VBA / Extract images in

›
How to Save Word Document as WebPage using VBA I have some lazy friends who come up with strange requirements. One such guy wanted me to e...

How to Increase / Decrease Size of Images in Word Document using VBA

›
Scaling of Pictures / Images using Word VBA The following code scales all the pictures of the Word document Function Scale_Pictures(ByRe...

How to insert field in Word 2007/2010

›
To insert Field in a Word document, select the Quick Parts option from Insert tab Click on the Field, which will throw the following d...
3 comments:

How to Select a Web Page from Excel / Word using VBA

›
How to Select a Web Page from using Excel / Word VBA The following code uses GetOpenFilename method to select the Webpage (HTML here) Su...

How to Check Internet Connectivity using VBA

›
The following code snippet uses API functions to check Internet connectivity and also the type of connection : Public Declare Function Int...
2 comments:
Saturday, May 08, 2010

How to Dynamically Change Userform's Control properties from Excel Sheet using Excel VBA

›
How to Draw Rectangle in VBA using Excel Data This is an exclusive request from Phil. If you find it interesting, I am more glad. The idea ...
Saturday, April 24, 2010

How to Save Powerpoint Presentation with Password using VBA

›
How to Specify the Password in SaveAs option in PowerPoint VBA Unlike SaveAs in Word/Excel, which takes the Password as part of the argume...
1 comment:

How to Convert Automatic Hyphens to Manual Hyphens using Word VBA

›
Word does automatic hyphenation at the end of line when the AutomaticHyphenation feature is turned on ActiveDocument.AutoHyphenation = Tru...
1 comment:
Friday, April 23, 2010

Unprotect and Protect Sheet using VBA code

›
How to write to protected Excel file using VBA Here is a sample to unprotect a sheet and write some values and then protect the sheet again...
Monday, March 29, 2010

How to clean Office Solution - .NET

›
How to clean Office Solution from Visual Studio / How to unistall Excel/Word addins using Visual Studio Use the clean option in Build Menu t...
Tuesday, February 16, 2010

Enable Developer Tab in Office 2010

›
How to enable Developer Tab in Office 2010 If the developer tab is not showing on your Ribbon UI, you can enable it from Application Options...
2 comments: