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
--
PaulC
------------------------------------------------------------------------
PaulC's Profile:
http://www.excelforum.com/member.php...fo&userid=7563
View this thread:
http://www.excelforum.com/showthread...hreadid=534989