Thread: run word macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
gord_lawson gord_lawson is offline
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
.