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: 9948
Rarely I've come across the following problem in Excel VBA.
Some source code is definitely correct, but it just won't compile. I could one time confirm different Excel versions to be the root cause of the issue. Even though I slightly adjusted the source code in the target version of Excel, the compiler still showed funny error messages.
The trick that did solve the issue in the end was to cut the whole source code, compile and save the empty source code objects (modules, classes, etc..), paste the source code into target objects again and then compile as well as save in the target version of Excel.
From my understanding the file still held bits of the older version of Excel. However, I experienced this also using the same version of Microsoft Access on the same machine. Cutting and then pasting the source code with saving in between did the trick again.
- Hits: 8817
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: 8982
Page 2 of 4