Run a Word Macro from Excel
I found the answer on Google...
'RUN A WORD MACRO FROM EXCEL WHEN WORD IS ACTIVE
Set WdApp = Word.Application
With WdApp
.Application.Run MacroName:="Normal.NewMacros.letter" & Ans
End With
--
Regards,
Rocky McKinley
"Rocky McKinley" wrote in message
...
Hi I need to run a a word procedure from Excel:
MacroName: "letter1"
Procedure Location: "Normal"
Document Name: "ActiveDocument"
Word will already be active with a new Email, addresses, subject already
filled in. I just need to call "letter1" to insert formatted text in the
body of the message.
Thanks in advance,
--
Regards,
Rocky McKinley
|