Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to Word Macro | Excel Discussion (Misc queries) | |||
Using Word from Excel Macro. | Excel Discussion (Misc queries) | |||
Printing a Word doc with a macro | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Macro - Open Word with Excel macro | Excel Discussion (Misc queries) |