Pages

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

How to add a user defined function to a Category using Excel VBA Macro

›
How to Categorize the User Defined Function using VBA Macro The following code adds the Get_Net_Working_Days UDF to the Date & Time Cate...
2 comments:
Sunday, January 25, 2009

How to select a Named Range in a Workbook using VBA

›
The following snippet will select the specified named range Function Goto_A_Name(ByVal sName As String) As Boolean ' On Error G...
2 comments:

Restrict Multiple Instance of Visual Basic Application

›
How to Prevent Visual Basic Exe being executed multiple times At times we set/reset registry settings / environment variables as part of t...
Wednesday, January 07, 2009

Only comments may appear after End Sub, End Function, or End Property

›
Only comments may appear after End Sub, End Function, or End Property One possibility of this error might be because of the Declare stateme...
1 comment:

Constants, fixed-length strings, arrays, user-defined types and Declare statements not allowed as Public members of object modules

›
Declaring the following in a Userform is one possible cause for the error: Declare Function apiFindWindow Lib "User32" Alias ...
3 comments:

How to Windows Explorer using VBA

›
How to Open a Folder in Windows Explorer using VBA ShellExecute() Windows API function can be called from a VBA macro to start another pro...
11 comments: