VBA Procedures Index
Our source code can be used with VBA for Office 2000 and higher
and VB6. Both
Visual Basic built-in procedures and our procedure library (and your own code)
are easy to find and use from the Code
Line builder.
A separate code fragments library shows how to achieve certain programming goals.
Files and folders
- FileErrors Error Handler
- Directories and Files Index
- Extract FileName from FullPath
- Private Declare Function apiGetTempDir Lib
- Test If File Exists
- Test If Folder Exists
- Whether or not to use the File System Object
- Read String of Text or HTML from a File
String functions
- Checking if two strings are equal
- Count Occurrences In A String
- Count Parts in Delimited String
- Joining Variables Into A String With Delimiter
- Purge Characters from String
- Return Nth item from delimited string
See also String handling fragments
Working with Dates
See also Calculate Date - code fragments
Excel
- Convert Column Position Numbers to Column Letters
- Find first cell with a value in row or column
- Test If There Is An Open Workbook With Certain Name
- Test If Sheet Exists
See also Excel VBA code fragments
International
- Function DoubleReadValue - decimal separator problem
- Interpret input value who's settings are different from the system
Performance
Sort