| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execute a macro in another file with an argument
Using Office 2003 and Windows XP;
I need to call a program from a currently active XL file to another XL file; I know you can a syntax like: Application.Run "'FullFileName'!MacroName" However, I need to supply an argument in this call, but the following doesn't work: Application.Run "'FullFileName'!MacroName(MyArgument)" MyArgument is a variable name; how can this be done? Thanks much in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using file name as argument in function | Excel Programming | |||
| Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
| Execute macro at opening file | New Users to Excel | |||
| Function (array argument, range argument, string argument) vba | Excel Programming | |||
Threaded Mode
