Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default run word macro

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default run word macro

here are 2 subs that might work for u that i happen to
have linked to a button...

Private Sub CommandButton17_Click() 'OPEN All
Workbooks.Open Filename:="C:\My Documents\Estimator\GL CM
SS.xls", UpdateLinks:=3
Workbooks.Open Filename:="C:\My Documents\Estimator\GL CM
VLT.xls", UpdateLinks:=3

For Each w In Application.Workbooks: w.Activate:
Application.Run "Macro2"
Next w
Windows("GL CM RDG.xls").Activate
End Sub

Sub Macro2()
Application.Run "'GL CM RDG.xls'!M20ShortcutKeys"
End Sub

-----Original 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
Excel to Word Macro Liz J[_2_] Excel Discussion (Misc queries) 1 December 2nd 09 08:27 PM
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


All times are GMT +1. The time now is 11:25 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"