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
|