Execute Excel Macro from another workbook_TJ
 

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

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

Execute Excel Macro from another workbook_TJ
 

Thank you...this works perfectly

"Gary''s Student" wrote:

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