View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Execute Excel Macro from another workbook_TJ

Sub dural()
Run "Bookxx.xls!Hello"
End Sub

Assuming that Bookxx.xls is open.
This runs a macro in that book.
--
Gary''s Student - gsnu200830


"ambushsinger" wrote:

I have a workbook that runs a script to populate another wokbook with data.
The destination workbook has a macro that formats the data in the sheet.
Can I programmatically kick off this macro from the script in the first
workbook?

TJ