How to run Word macro in Excel macro

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I am trying to run a Word macro in Excel macro. Could
someone show me an sample?
Thanks
Kevin
 
Kevin,

Try something like the following


Dim WD As Word.Application
Dim Doc As Word.Document
Set WD = New Word.Application
With WD
Set Doc = .Documents.Open("C:\doc1.doc")
.Run "Doc1!TheMacro"
Doc.Close savechanges:=False
.Quit
End With



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Excel 2007: Help creating a macro that will run Solver? 3
Word to Excel: Export comments with text and line number 0
Pasting cell contents into a macro 1
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
How to stop running macros everytime I run excel? 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel TWO Instances of Excel One watching Other 3

Back
Top