Pages

▼
Monday, July 27, 2009

How to change the Source of Pivot Table using VBA

›
How to configure Pivot Table source data externally through VBA A Pivot Table is linked to a particular source data. If for some reasons, yo...
4 comments:

How to Check the Source Type of Pivot Table using VBA

›
Excel VBA Check Pivot Source The following snippet could help in getting the source type of the Pivot Table Sub CheckSourceConnection() ...

How to Add Popup Menu Item in Excel/Word using VBA

›
Create Popup Menu (Right Click menu) using VBA Here is a simple snippet that will add a menu item to the popup menu and assign a macro to it...
1 comment:
Wednesday, July 22, 2009

How to Create PDF from Word Document using VBA

›
Convert Word to PDF using VBA Word 2007 has a new method - Document.ExportAsFixedFormat, which saves the document as PDF or XPS format The f...
12 comments:
Saturday, July 18, 2009

Welcome Office 2010

›
At last the Office 2010 is out - here is what Microsoft has to say about its new baby: "Microsoft® Office 2010 gives you rich and power...
1 comment:
Thursday, July 16, 2009

VBA Additional Contols not enabled in Tools menu

›
Probably a silly one, but it took some good time of one of my student. So if the 'Additional Controls' in Excel VBA/Word VBA window ...
6 comments:
Tuesday, July 14, 2009

How to Create New Menu using Excel VBA

›
How to automatically add menu to Excel using VBa Here is a code to add a new menu and a button whenever a sheet is opened. Option Explicit P...
5 comments:
Sunday, June 07, 2009

How to have userform on when working with Word / Excel

›
How to use Excel and Word Application when userform is displayed Many times you need to show the userform and work with the application (Exc...
1 comment:
Sunday, May 24, 2009

How to Reply to Mail using Outlook VBA

›
Copy formatted word document to Outlook mail using VBA Here is a simple snippet that replies to the mail using VBA. The contents of the docu...
4 comments:
Wednesday, May 20, 2009

Save Powerpoint Slides as Images using VBA

›
VBA Code to Convert Ppwerpoint Slide to Image (JPEG) Here is a simple code that will Export all slides in a powerpoint presentation to Jpeg ...
7 comments:
Friday, May 08, 2009

Disable Close button using Excel VBA

›
How to disable close button using VBA If you want to prevent the user to close the Application, you block the menu items, keypress etc. This...
2 comments:
Wednesday, May 06, 2009

Kill Residual Excel Process using VBA

›
Here is a simple VBA code to "Kill" the Excel process using VBA Sub Kill_Excel() Dim sKillExcel As String sKill...
12 comments:
Monday, April 27, 2009

How to Kill the Word Process using VBA

›
Developers who are working on Word VBA would have experienced the Word Crash problem more often. Here is a crude way to kill the Word proces...
8 comments:

Reset Auto Filter and unhide Rows and Columns using Excel VBA

›
Autofilters and hidden cells are a nemesis when you perform some operations. The following simple macro will unhide all rows/columns and tur...
Sunday, March 15, 2009

How to Save a Chart as Image using Excel VBA

›
Here is the way to save the active chart in Excel 2007 to a JPG file. It is better to size the chart appropriately before exporting it as ...
7 comments:

How to Install Analysis ToolPak in Excel 2007

›
How to Install Analysis ToolPak in Excel 2007 Click the Microsoft Office Button , click Excel Options , and then click the Add-ins categor...
7 comments:
Saturday, March 14, 2009

How to Connect SQL Express 2005 from VBA

›
Excel VBA retrieve data from SQL Server 2005 Here is a way to connect to SQL Express 2005 from Excel VBA Sub Connect2SQLXpress() Dim ...
9 comments:
Saturday, March 07, 2009

How to update an Access Table using VBA

›
How to update an Access Table using ADO The following code snippet would be helpful to update an Access 2007 database table using VBA. The c...
8 comments:

No value given for one or more required parameters. (ADO Error)

›
There are many reasons for this error: Parameter name not spelt correctly Case is not correct in parameter (firstname instead of FirstName )...
4 comments:
Sunday, February 22, 2009

How to extract all synonyms of a given word using VBA

›
The following code snippet gives a hint on how to extract synonym list using Word VBA Sub Retrieve_Word_Info() Dim arSynonyms Dim oSynInfo ...
1 comment: