Execute Excel Macro from another workbook_TJ

[ambushsinger]

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

 

[Gary''s Student]

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

Assuming that Bookxx.xls is open.
This runs a macro in that book.

 

[ambushsinger]

Thank you...this works perfectly

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

Assuming that Bookxx.xls is open.
This runs a macro in that book.