Pages

▼
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:
Monday, February 15, 2010

Run Excel Macro from Powerpoint VBA

›
How to Run an Excel Macro from PowerPoint Before writing code for doing it you need to add Excel Library to the PowerPoint VBE Project Power...
7 comments:
Saturday, February 13, 2010

Office 2010 - Application.FileSearch Error

›
Application.FileSearch doesn't work in Excel 2010 (Office 2010) Application.FileSearch didn't work in Office 2007 (It has been depr...
3 comments:
Saturday, February 06, 2010

How to check compatibility issues in a Word Document

›
How to check compatibility issues in an Office Document Microsoft Office is getting polished rapidly. Upgrades from 2003 to 2010 saw sea cha...

Show All Comments using Excel VBA / Hide All Comments using Excel VBA

›
The following code is a easier way to show all comments in the Excel Spreadsheet. This comes handy when you want to view all the comments to...