| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a macro in another WB
Excel XP & Win XP
I have files AAA.xls and BBB.xls open. I am running code that is in AAA.xls. I want to run macro MyProc that is in BBB.xls. For that I use this code: Application.Run "BBB.xls!MyProc" I get the error that the macro cannot be found. I checked the file and macro names and they are right. Is the Application line syntax not right? Thanks for your time. Otto PS: The 2 files reside in different folders. Could that be a problem? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Report with macro losing links to a particular worksheet after running macro | Excel Programming | |||
| disable user running macro from Tools Macro | Excel Discussion (Misc queries) | |||
| Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
| how to get onkey macro to fire while another macro is running | Excel Programming | |||
| Launch Macro in Access via Macro running in Excel??? | Excel Programming | |||
Threaded Mode
