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