Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run a Word Macro from Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to Word Macro | Excel Discussion (Misc queries) | |||
Using Word from Excel Macro. | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Macro - Open Word with Excel macro | Excel Discussion (Misc queries) | |||
Using Word and Excel in one Macro | Excel Programming |