| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running Macro
Hi everyone,
I have a macro called "Load" in workbooks("A".xls) which works perfectly. I am just trying to run different macro "ABC_Load" in workbooks("B".xls) before I run macro in workbooks("A".xls) How do I call this macro from current workbook A? Workbook B is located C:\My Documents\ Macro name: ABC_Load Thank you in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running Macro
You need to have the other workbook open
Application.Run "'B.xls'!ABC_Load" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "James8309" wrote in message ... Hi everyone, I have a macro called "Load" in workbooks("A".xls) which works perfectly. I am just trying to run different macro "ABC_Load" in workbooks("B".xls) before I run macro in workbooks("A".xls) How do I call this macro from current workbook A? Workbook B is located C:\My Documents\ Macro name: ABC_Load Thank you in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable running of SelectionChange macro when in another macro? | Excel Discussion (Misc queries) | |||
| 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 | |||
| Launch Macro in Access via Macro running in Excel??? | Excel Programming | |||
Linear Mode
