ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   run word macro (https://www.excelbanter.com/excel-programming/277284-run-word-macro.html)

T. Alksndr rstrpo Prado

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

gord_lawson

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
.



All times are GMT +1. The time now is 01:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com