Pages

▼
Tuesday, June 19, 2007

Visual Basic Common Dialog

›
Opening Files with Common Dialog Common Dialog not only replaces three controls (Drive, Directory and FileList), but also is easier to progr...
14 comments:
Monday, June 18, 2007

Excel VBA - install an Excel Add-in (XLA or XLL)

›
Adding Addins Automatically using VBA Most of today's Excel VBA code are as Addins (XLA or XLL). As an organization progresses there com...
8 comments:

Show All Processes using VBA

›
Get All Processes using Win API Functions 'Declarations Const TH32CS_SNAPHEAPLIST = &H1 Const TH32CS_SNAPPROCESS = &H2 Const TH...
Wednesday, June 13, 2007

Run a VB6.0 Executable from Excel/Word

›
Run an Executable from Excel VBA / Word VBA If you need to use some grid for showing data / use the feautres in Visual Basic 6.0 that arenot...
1 comment:

VBA Read Text Files (With Leading & Trailing Spaces)

›
Read Data frm Text Files (VBA) Reading Text Files using VBA is one of the major development activity of programmers. There are multiple ways...
17 comments:

Extract Procedure Names from all Modules - VBA

›
Count No of Programs in a Workbook Workbooks have Macros, If you need to know if the Workbook contains macros and then the following proc wi...
4 comments:

ColorIndex - Coloring Excel Sheet Cells

›
Highlight Color in Excel Cells Colorindex is used to color the background of Excel Cells Cells(1, 2).Interior.ColorIndex = 30 etc Here is...
7 comments:

Excel VBA - Delete Empty Rows

›
Delete Rows without Values Here is a primitive simple function to delete rows that does not contain any value (I have taken Cols 1 to 10) fo...
Friday, June 08, 2007

Setting Default & Cancel Buttons in VBA/Visual Basic

›
VB/ VBA Setting Default & Cancel Buttons through code Private Sub Form_Load() 'Sets cmdOK as the button control that is clicked when...
2 comments:
Saturday, June 02, 2007

Assigning Shortcut Keys - Excel Macros

›
Shortcut Key Assignment for Subroutines It is always nice to have keyboard shortcuts for executing functions/subroutines rather than having ...
8 comments:

Using Function Keys in Visual Basic Forms

›
Function keys as Shortcut Keys in VB Function keys are a boon for assigning shortcuts. They have more advantage than the regular Alt + or C...
6 comments:
Sunday, May 27, 2007

Save copy of the workbook

›
Sub Saving_A_Copy_Of_Workbook() 'Saves a copy of the workbook to a file but doesn't modify the open workbook in memory Dim bAchieved...
8 comments:

Print Multiple Sheets using VBA

›
' VBA to Select Multiple Sheets Sub Print_Selected_Sheets() ' Remove Multiple Selections ActiveWorkbook.Sheets(1).Sel...
1 comment:

VBA Dir Function to Get Sub Directories

›
Get Sub Directories using VBA Dir Function The below function is used to get the immediate sub-directories for a given directory. If you wa...
8 comments:
Saturday, May 26, 2007

Insert Procedure to a Module Using VBComponents

›
Insert Procedure to a Module Using VBComponents Sub Insert_PRocedure_To_BasModule() ' This program will need reference to Microsoft Visu...
1 comment:

Delete Module on the Fly using VBA

›
VBA Delete Bas Module / Class Modules Sub Delete_BasModule_To_WorkBook() ' This program will need reference to Microsoft Visual Basic fo...

Insert User Form on the Fly

›
Automatic Creation of User Form Sub Insert_Form_To_WorkBook() ' This program will need reference to Microsoft Visual Basic for Extensibi...
1 comment:

Insert Class Module on the Fly

›
Dynamic Insertion of Class Module Sub Insert_Class_Module_To_WorkBook() ' This program will need reference to Microsoft Visual Basic fo...

Insert Module on the Fly

›
Dynamic Insertion of Bas Module using VBComponents Many a times we need to create Workbook through program and add some code to the workbook...
Monday, May 14, 2007

Match Excel Column against a Standard Range

›
Replace Values of a Column when it Matches If you want to match the names in column2 against the standard names in column 1 & replace by...