I have a number of templates in the Microsoft Office\Office\startup folder, and would like to run one of the macros from a shell command in VB.
So, my code says something like:
Shell "Winword.exe /mLaunchDocumentWizard"
This launches Word, but does not run the macro. This does work if I open the document containing the macro first, but this is not an option in my app.
The LaunchDocumentWizard subroutine compiles
The LaunchDocumentWizard is a valid macro (public sub, no parameters)
How do I run a macro without opening the document which contains it?