G Guest Sep 14, 2007 #1 Is there a way in VB to run a macro or function from another Excel workbook? If so how can I do this?
Is there a way in VB to run a macro or function from another Excel workbook? If so how can I do this?
G Guest Sep 14, 2007 #2 application.run "myBook.xls!myMacro" http://msdn2.microsoft.com/en-us/library/aa167683(office.10).aspx
application.run "myBook.xls!myMacro" http://msdn2.microsoft.com/en-us/library/aa167683(office.10).aspx