Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to launch an external program using a macro and open a project in the
process. The executable file resides on a shared drive as does the project I need to open. I've looked at the shell command but can't figure out how to pass the variables. I keep receiving the following message: Compile error: Expected: List separator or ) There is a different version of the software installed on the local hard drive and it will try to open the project from there, but that won't work. So I need to specify the "start in" folder for it to work properly. Program resides he g:\apps\my prog\myprog.exe Project resides he g:\files\ my project\myprojname.xxx So I have this but it doesn't work. How can I modify it so it will launch using the executable from the shared drive? RetVal = Shell("g:\apps\my prog\myprog.exe" "g:\files\ my project\myprojname.xxx", 1) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compile Error: Expected Array | Excel Programming | |||
compile error - expected an array | Excel Programming | |||
compile error: Expected: = ...Why? | Excel Programming | |||
Compile Error: Expected End Property | Excel Programming | |||
compile error: expected variable or function | Excel Discussion (Misc queries) |