I am trying to run a Word macro from Excel. The Macro, called DocumentSave1 is saved in the ThisDocument folder of the WrapUpTemplate file (see code). The relevant part of the code is:
Dim wdApp as Word.Application
Set wdApp = CreateObject("word.application")
wdApp.Documents _
.Open("P:\Spreadsheet Project\WrapUp\" & WrapUpTemplate) _
.Application.Visible = True
wdApp.Activate
With wdApp
....various word coding to copy text into template (this all works fine)
DocumentSave1
End with
I just don't know how to get it to go to the Word macro. I have tried moving DocumentSave1 to the Modules folder, but that does not seem to work either.
Any help with this would be very gratefully received,
Paul
Bookmarks