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?

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.


OzGrid Business Applications