Execute Excel Macro from another workbook_TJ

  • Thread starter Thread starter ambushsinger
  • Start date Start date
A

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
 
Sub dural()
Run "Bookxx.xls!Hello"
End Sub

Assuming that Bookxx.xls is open.
This runs a macro in that book.
 
Thank you...this works perfectly

Gary''s Student said:
Sub dural()
Run "Bookxx.xls!Hello"
End Sub

Assuming that Bookxx.xls is open.
This runs a macro in that book.
Click to expand...
 
Back
Top