Pages

▼
Wednesday, September 26, 2007

Reducing Size of Microsoft Access Database (Compact Database)

›
Compact MS Access Database using VBA (ADO Code) If the DB Size is huge the compact DB utility [Compact & Repair Database (Tools-->Dat...
Saturday, September 15, 2007

Excel VBA - Change Font Color for Part of Text

›
Formatting Text (Cell Contents) Partially using Excel VBA Sometimes, you need to differentiate some parts of text in an Excel cell. This can...
11 comments:

Orientation of Cell Through Excel VBA

›
Almost most of the Excel VBA programmers would have the requirement to change the orientation of the cell. Here is an example Sub Orientatio...
2 comments:
Tuesday, August 21, 2007

ShutDown Windows using VBA

›
VBA Function to Logoff /VBA Function to Restart Windows Option Explicit ' Win API Declarations Const MF_BYPOSITION = &H400& Priv...

Disable Close Button in UserForm (VBA)

›
Disable Close Button in Userform (Visual Basic) Option Explicit 'API Declarations Const MF_BYPOSITION = &H400& Private Declare F...
3 comments:
Sunday, August 12, 2007

Detecting duplicate values (Excel VBA)

›
Check presence of values in a column/range using Excel VBA Most often a programmer would be given a job of Insert/Update scenarion in EXcel....
17 comments:

Automatically Event Repeat in Excel VBA (OnTime Method)

›
VBA Code that can run at a fixed time can be done using the OnTime Method. OnTime Method schedules a procedure to be run at a specified tim...

Disable Cut & Copy from Popup menu (Excel VBA/Word VBA)

›
Here is a simple way to disable the Cut & Copy in the Popup menu Sub Disable_Buttons() Dim oC1 As CommandBar Set oC1 = Application.Comm...
Wednesday, July 25, 2007

Excel Height of Row - RowHeight using Excel VBA

›
RowHeight property is used to get the Height Returns the height of all the rows in the range specified, measured in points (point: Unit of m...
Sunday, July 08, 2007

Get the Height & Width of Shapes / Figures in Word Document (Word VBA)

›
Height & Width of Shapes / InlineShapes in Word Document (Word VBA) Figures are embedded in the word document and when they move they ar...

Paragraph & Character Styles in Word Document (Word VBA)

›
Export Character Styles from Word Document / Export Paragraph Styles from Word Document Here is the simple macro for extracting character ...
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: