MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Run macro in another workbook?


Posted by Ben on April 22, 2001 5:46 AM

How do I run a macro in another workbook?
Thanks


Posted by Dave Hawley on April 22, 2001 8:07 AM


Hi Ben

As long as the other Workbook is open you would do this:

Sub MacroInAnotherOpenBook()

Application.Run "OtherWorkbookName.xls!MyMacro"

End Sub

This would run the Macro "MyMacro" in another Workbook.


Dave

OzGrid Business Applications