Pages

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

VBA code to get system free space

›
How to get the free space available using VBA The FreeDiskSpace property can be used to retrieve the free space information from Word VBA Su...
1 comment:

How to disable user from using short-cut keys using VBA

›
How to disable shortcut keys in VBA You can disable the keybinding using the following code Sub VBA_Sys() ' Disable Ctrl + S FindKey(Bu...
1 comment:

Word VBA to get System Resolution

›
How to get System Resolution using VBA Sub VBA_System_Resolution() MsgBox System.HorizontalResolution & " X " & System.V...

Programmatically Open and Repair workbook using VBA

›
How to Repair Excel Workbook using VBA The following code uses VBA to open and repair the workbook (the option available using Excel Open Di...
2 comments:

How to use non-contiguous range of cells in Excel VBA

›
Here is a way to update a range that is not contiguous using VBA Sub NonContiguous_Range_Example() Dim oRng As Range Set oRng = Range(...
6 comments:
Saturday, February 07, 2009

How to insert data to a database with Access AutoNumber Field using VBA

›
SQL Command to Insert Data to a Table with AutoNumber Field Access creates its own Primary Key, which is an AutoNumber field – no trouble if...

How to Insert Data to an Access 2007 Database Table using Excel VBA

›
VBA code for inserting data to Access 2007 database Inserting data to Access database can be performed from VBA using ADO commands. The foll...
22 comments:
Sunday, February 01, 2009

Method 'MacroOptions' of object '_Application' failed

›
The error occurs due to various reasons 1. The Function corresponding to Macro name is not in a code module (it might be in Sheet/Work...
1 comment: