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
.
|