Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Word from Excel Macro. sharad Excel Discussion (Misc queries) 1 September 17th 07 07:24 PM
Printing a Word doc with a macro Alec H Excel Discussion (Misc queries) 0 February 23rd 06 10:46 AM
passing arguments from an excel macro to a word macro KWE39 Excel Discussion (Misc queries) 1 July 7th 05 03:56 PM
Macro - Open Word with Excel macro Bill Excel Discussion (Misc queries) 3 May 23rd 05 11:21 PM
run word macro T. Alksndr Rstrpo Prado Excel Programming 1 September 17th 03 10:03 PM


All times are GMT +1. The time now is 07:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"