How to call up a macro in a different location?

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save as a new format name automatically 2
Unhide macro worksheet 2
Excel TWO Instances of Excel One watching Other 3
how to prevent macros in Personal.xls appearing in other workbook 3
Read Only 3
Editing a macro which is within another macro. 3
macro than refers to a cell? 1
Macro Will Not Save 2

Back
Top