How to call up a macro in a different location?
 

When I am running a macro "ABC" located in Personal.xls, how can I
call up a macro "XYZ" located in another open workbook,
MyWorkBook.xls? Thanks for your help.

TIA
Tom

How to call up a macro in a different location?
 

Dim wkbk as workbook
dim macroname as string
set wkbk workbooks("myworkbook.xls") 'it has to be open
macroname = "xyz"
application.run "'" & wkbk.name & "'!" & macroname

==
or just
application.run "myworkbook.xls!xyz"
or
application.run "'my workbook.xls'!xyz"
(if your workbook name has spaces)


Tom wrote:

When I am running a macro "ABC" located in Personal.xls, how can I
call up a macro "XYZ" located in another open workbook,
MyWorkBook.xls? Thanks for your help.

TIA
Tom

--

Dave Peterson