| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Use pic location string to call up picuture in cell? | Excel Discussion (Misc queries) | |||
| Asynchronous call (macro) | Excel Discussion (Misc queries) | |||
| macro call | Excel Discussion (Misc queries) | |||
| How Can I call any form or macro.. | Excel Worksheet Functions | |||
| How to call a macro in an XLA add-in | Excel Discussion (Misc queries) | |||
Linear Mode
