Pages

▼
Sunday, February 22, 2009

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:

Suppress "Opening this will run the following SQL command" message using Registry – Word Mail Merge

›
How to s uppress "Opening this will run the following SQL command" message using Registry – Word Mail Merge Here is a method to ...
Sunday, January 04, 2009

How to Show Field Codes in Word Document – using VBA

›
Word VBA – Show Field Codes Here is a simple way to show the field codes in Word Sub Show_Field_Codes() Application.ActiveWindow.View.ShowF...

How to Hide Field codes in a Word Document using VBA

›
Word VBA – Hide Field Codes The following snippet will hide the field codes present in Word document. Sub Hide_Field_Codes() Application.Ac...

How to Insert Document Properties in Word Document

›
Update Document Properties in a Word document using Field codes Field codes are the best tool for any Word users. They are rich source of pr...
7 comments:
Thursday, January 01, 2009

How to delete Folder using VBA

›
VBA RmDir Method Here is a simple method to delete the entire folder using VBA Sub Delete_Folders_FS() Dim sFolder As String On Error Go...
3 comments:

How to Convert Decimal to Hexadecimal using VBA

›
How to Convert Decimal to Octal using VBA Sub Get_Hex_n_OCt_Values() For i = 0 To 255 Debug.Print i & vbTab & Hex(i) & vbT...

Enable AutoRecovery using Word VBA / Set Auto Recovery Duration using VBA

›
The following code will help to set the AutoRecovery On using VBA. The frequency of Autorecovery Save can also be set / reset Sub EnableAut...