Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run word macro
http://support.microsoft.com/?id=177760
VBA: How to Run Macros in Other Office Programs (OFF 97) The following Sub procedure assumes that the document WordDoc.Doc contains a macro called "WordMacro." here is the example: Sub WDTest() Dim WD as Object Set WD = CreateObject("Word.Application") WD.Documents.Open "C:\My Documents\WordDoc.Doc" ' Note that the project name and module name are required to ' path the macro correctly. WD.Run "Project.Module1.WordMacro" End Sub -- Regards, Tom Ogilvy "T. Alksndr Rstrpo Prado" wrote in message ... Hi, good day for you. I have this problem I have a excel workbook, and I have a macro on it, I need this macro in excel open a word document and run a macro on that word document. How I do that? can do I do that? thanks a lot Be good The force be with you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Word from Excel Macro. | Excel Discussion (Misc queries) | |||
Printing a Word doc with a 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) | |||
run word macro | Excel Programming |