Quote:
Originally Posted by constructionjasont
TWould there be a reason then that it doesn't work running a macro in Excel? I have the excel vba as shown below, it will open the source document, but won't run the word macro. But if I run said macro directly through word it does fine. I tried finding a solution, but from what I can tell it should work?
|
For starters, if the Word document you're trying to open is a mailmerge main document, the whole process will stall as soon as the document opens, because Word will be waiting for you to respond to the SQL prompt that you get when opening such a document.
There are ways around that, but the coding becomes a whole lot more complex. See, for example:
https://www.msofficeforums.com/mail-...html#post61768. Even that code doesn't generate the individual Word documents - you'd need to integrate the two approaches.