run word macro

  • Thread starter Thread starter T. Alksndr Rstrpo Prado
  • Start date Start date
T

T. Alksndr Rstrpo Prado

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
 
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
 
Back
Top