Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling macros from a VB app
I currently run macros from a VB application, and my code within
the app looks something like: ShellExecute(0&, vbNullString, "excel", q & file_to_operate_on & q & q & file_macro_is_in & q, vbNullString, vbNormalFocus) However, I wanted to ask, suppose file_macro_is_in has many macros defined in it, and I want to execute only one particular one. Does Excel have any command line arguments that would allow me to do this? For instance, making something along the lines of the following possible: ShellExecute(0&, vbNullString, "excel", q & file_to_operate_on & q & q & file_macro_is_in & q & "-mymacroname", vbNullString, vbNormalFocus) Also, so that I don't ask too many questions that could probably be answered by some reading, can anyone recommend a source for thorough documentation on the Excel API + command line arguments to Excel? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CALLING MACROS FROM A NEW WORKSHEET | Excel Discussion (Misc queries) | |||
calling macros from worksheet to another | Excel Discussion (Misc queries) | |||
Calling macros in another workbook | Excel Worksheet Functions | |||
Calling Macros from a list | Excel Programming | |||
Calling macros in another spreadsheet | Excel Programming |