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