VBA - Visual Basic for Applications
Whenever I have to write data into a text file following function has proven to fulfill my needs.
In case you want to export a file in Unicode encoding you just hand True for the parameter isUtf16Le, which will cause the FileSystemObject to encode the file in UTF-16 with low byte order mark (little endian).
- Hits: 12511
If you want to export a collection of type Scripting.Dictionary into a text file the below function may come handy.
- Hits: 9703
The following code snippet will show you how to use regular expressions in VBA.
- Hits: 10694
Excel VBA Article Count: 30
This category will hold articles regarding developement in Excel VBA. It will serve as a wiki and an Excel VBA Framework for myself.
Some development tasks reoccur for every customer. Since I am a lazy bum it will be nice to have a central source where I can reuse source code from.
MS Office and VBA Article Count: 11
This category holds articles regarding general things in MS Office VBA independent from the MS Office application.
Power Point VBA Article Count: 1
Page 1 of 17