MS Office and VBA
This category holds articles regarding general things in MS Office VBA independent from the MS Office application.
If you want to export a collection of type Scripting.Dictionary into a text file the below function may come handy.
- Hits: 10222
The below method will replace all special or escape characters in a provided String.
This is of use, if you have to use before unknown Strings from any source for example in a file name.
- Hits: 9201
If you have to create and send an email automatically, the following method might help.
I have not tested it with HTML yet, but will do that at some point.
The method requires MS Outlook to be installed, since it is automating Outlook in order to create an email with attachment.
- Hits: 9297
Page 2 of 4