Pages

▼
Tuesday, November 25, 2008

Call a Method in VSTO Addin from Visual Basic Applications

›
How to call a VSTO Addin Function from VBA VSTO Addins we write might contain good number of reusable components. The following article show...
4 comments:

Copy Array Values to Excel Range using VSTO

›
Insert Array to Excel Range using VSTO Many times we need to insert text to a contiguous Excel range using VSTO (like column headings). The ...

How to Return Multiple Values from a VBA Function

›
Return Multiple Values from a Visual Basic Function A normal VBA function has a return statement that returns a value to the calling functi...
4 comments:

How to insert Symbols in Word Document using VBA

›
Here is a simple way to insert the commonly used symbols (Copyright, Trademark etc) using Word VBA Sub Insert_Symbols_Example() Selection.Ty...
6 comments:
Saturday, November 22, 2008

How to use collections in Excel VBA

›
Collection of objects using Excel VBA Collection provides a convenient way to refer to a group of objects and collections as a single object...
10 comments:

Convert Decimal to Percentage using VBA Format Function

›
Convert Decimal to Percentage using VBA FormatPercent Function Here is a simple example to convert a decimal to percentage using VBA funct...
6 comments:
Saturday, November 08, 2008

How to Read and Write Configuration Files using VBA

›
How to Read and Write INI files using VBA Ini files were extensively used for storing configuration path. Of late this has been replaced wit...
6 comments:
Saturday, October 11, 2008

Programmatically add macro to Excel Workbook using VBA

›
Insert Code Module to Workbook using Excel VBA There are numerous instances where code/macro needs to be added to the workbook on the fly. T...

VBA check program modes

›
How to check if the program is in debug mode using VBA Here is a simple way to check if the program is in debug mode using VBA Sub ...

Excel VBA TimeStamp – Milliseconds using Excel VBA

›
How to Get Time in Milliseconds using Excel VBA The following function uses Timer function to get the milliseconds and append it to the curr...
5 comments:

Excel VBA uninstall Excel Addins

›
Programmatically uninstall Excel Addins using VBA Sub UnInstall_Addins_From_EXcel_AddinsList() Dim oXLAddin As AddIn For Each oXLAddin In Ap...
1 comment:

Word VBA add command buttons through code

›
Add CommandButton to Word Document using VBA (through AddOLEControl) Here is one of the ways to add a command button on a Word document ...
2 comments:

Manipulate ActiveX TextBoxes in a Word Document using VBA

›
Change Content of Embedded Textboxes in Word using VBA Word Document might contain text boxes embedded in it as Inlineshapes. In that ca...
1 comment:

Automatically Tag Underlined Words using Word VBA

›
Tag Formatted Text in Word using VBA Here is a Word VBA snippet for searching text in a particular format, for example, underlined text ...

Programmatically Delete Word Addins from the Addins List using VBA

›
Delete Word Addins using Word VBA At times there will be quite a no of Addins that you would have tested in Word and they will line-up i...

UnInstall Word Addins using VBA

›
Here is a simple method to uninstall a Word Addin (.dot file) using Word VBA Private Sub UnInstalled_AllWordAddins() D...

Programmatically Add Modules/Addins to Word using VBA

›
Install Word Addins using VBA Here is a simple method to add a Word Addin (.dot file) using Word VBA Private Sub Add_Word_Addin() ...
Tuesday, September 30, 2008

Add Macro to Workbook programatically using Excel VBA

›
How to Add Macro to Workbook using Excel VBA Here is a simple procedure to add a macro to the current workbook using VBComponents Sub Add_Ma...
1 comment:
Wednesday, September 17, 2008

Add Controls Popup Menu using Powerpoint VBA

›
Powerpoint Application - Create Popup menu using VBA The following code is a simple one to create popup menu in Powerpoint using VBA Sub Add...