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