Pages

▼
Saturday, March 31, 2007

Save RTF document as word

›
Convert RTF document To Word Sub Open_n_Save() sFile = Dir$("C:\ReFormated\*.rtf", vbNormal) Do Until Len(sFile) = 0 Documents.Ope...
1 comment:

Using Excel Functions in VBA

›
Excel has several useful functions, which can be implemented in VBA code using the Evaluate Method Evaluate Method converts a Microsoft Exce...

Display text in a multiple lines

›
To display several lines of text in a text box, using vbcrlf at the end of each line Set MultiLine property to True either in the Properties...

Display Time Dynamically

›
Display Time Dynamically in Form using Time/Now Function Add a Timer Control to your form and set the timer interval. In the Timer event for...

Execute Excel Macro in All Files

›
You can use the following code to execute the macro in all Excel (.xls) files under a given folder. You can tweek a bit if necessary Sub Exe...
7 comments:

Get User Name using Split Function

›
This is a simple way of using the split function to get the user name Sub Get_EMail_User_Name() sEmail = " joe @gmail.com " arTemp...

Get Domain Name from eMail (Split Function)

›
This is a simple way of using the split function to get the domain name Sub Get_Domain() sEmail = " joe @gmail.com " arTemp = Spli...
1 comment:
Monday, March 26, 2007

Disabling Excel events

›
In some cases, we would have written some code in Worksheet_SelectionChange, Workbook_SheetActivate, etc and do not want them to be fired. T...

Excel Not Calculating Formula

›
If Excel does not re-calculate the formula. That is, if the cell is not refreshed inspite of newvalues, the Calculation might not be set as ...
2 comments:
Friday, March 02, 2007

Transferring array to Excel range

›
Is there any method to transfer the contents of the array to an Excel Range.. Most often programmers used to loop thru the array and put it ...
6 comments:

Character to ASCII

›
This function will print the ASCII values for corresponding characters in the first and second column respectively Sub Convert2_Asc_Values()...
4 comments:

ASCII to Character

›
There have been many times that we want to know the ASCII values. Ths function will print the character codes for the ASCII values in the fi...
1 comment:
Thursday, December 14, 2006

Shared Name For the Drive

›
QueryDosDeviceW API Function can be used to get the device name. To get the Shared Name of the drive, use the following function: Public Fun...

Get the Device Name (API Function)

›
Declare the API Function Private Declare Function QueryDosDeviceW Lib "kernel32.dll" ( _ ByVal lpDeviceName As Long, _ ByVal...

Dir Function in VBA (Visual Basic)

›
Dir or Dir$ Function can be used in Microsoft Visual Basic (Applications) to get the list of directories or files sDir = Dir$(sPath & ...
4 comments:

Excel VBA - How to Know if the Cell Has Formula

›
To get the cell that contains formula couple of useful properties are available in Excel VBA 1. HasFormula 2. SpecialCells(xlCellTypeFormula...
1 comment:

Excel VBA InputBox

›
Excel VBA InputBox InputBox method in Excel is more useful than the conventional inputBox functions when you require the user to select some...
1 comment:

MSFlexGrid datasource - Object variable not defined

›
When you try to use MSFlexGrid.datasource the error 'Object variable not defined; pops up. Try using the combination of Heirarchial Flex...
Friday, December 08, 2006

Faster Program Execution - Microsoft

›
Faster Program Execution is the dream of every developer. Here are some few tips for that. This is tested for Microsoft Visual Basic program...

BreakLinks - Microsoft Excel

›
Use the following code to break the links to external source in Microsoft Excel Workbook Sub Break_XL_Links() Dim oXlLinks oXlLinks = Active...
4 comments: