Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Thanks everyone for your help. I think Bob Phillips may be right. if the macro to run were in the same file as the macro calling it, the following would work: STRING = "'MACRO_WITHOUT_FILEPATH, "ARGUMENT 1", ETC '" Run STRING if the macro to run were in another file but had no arguments the following works: STRING = "FILE.xls!MACRO" Run STRING But no variations of these seem to work for the case of a macro taking arguments, and located in another file Thanks again. Ian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Correct Syntax | Excel Discussion (Misc queries) | |||
CORRECT SYNTAX FOR RUN... | Excel Programming | |||
Correct Syntax | Excel Programming | |||
Correct VBA syntax | Excel Discussion (Misc queries) | |||
Can't get this syntax correct, please help. | Excel Programming |