MS Office and VBA

This category holds articles regarding general things in MS Office VBA independent from the MS Office application.  

Whenever I have to write data into a text file following function has proven to fulfill my needs.

Source Code

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).

If you want to export a collection of type Scripting.Dictionary into a text file the below function may come handy.

The following code snippet will show you how to use regular expressions in VBA.

Source Code