Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launch program using Shell function
Thanks Rick, I initially tried with and without quotes and it didn't work. I
paid no mind to the error as I thought had to do with the syntax but I can see now that the application is not listed in my path statement and therein lies my problem. I will have to look for an alternative solution but thanks for confirming the syntax. PJ "Rick Rothstein" wrote: Use quote marks around the argument... RetVal = Shell("CALC.EXE", 1) -- Rick (MVP - Excel) "PJ" wrote in message ... Is it possible to launch an external program using VBA without specifying the application path? I want to launch a program where the location of the executable will vary based on the version installed on the users machine. The executable is the same regardless of the version installed and it appears there are at least four versions (and four locations) that could be present on the users machine. So instead of this: RetVal = Shell("C:\WINDOWS\CALC.EXE", 1) is there any way to achieve something like this: RetVal = Shell(CALC.EXE, 1) . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launch program using Shell function
I thought the CALC.EXE program resided in the System32 directory which I
thought was guaranteed to be in the Windows Path setting. -- Rick (MVP - Excel) "PJ" wrote in message ... Thanks Rick, I initially tried with and without quotes and it didn't work. I paid no mind to the error as I thought had to do with the syntax but I can see now that the application is not listed in my path statement and therein lies my problem. I will have to look for an alternative solution but thanks for confirming the syntax. PJ "Rick Rothstein" wrote: Use quote marks around the argument... RetVal = Shell("CALC.EXE", 1) -- Rick (MVP - Excel) "PJ" wrote in message ... Is it possible to launch an external program using VBA without specifying the application path? I want to launch a program where the location of the executable will vary based on the version installed on the users machine. The executable is the same regardless of the version installed and it appears there are at least four versions (and four locations) that could be present on the users machine. So instead of this: RetVal = Shell("C:\WINDOWS\CALC.EXE", 1) is there any way to achieve something like this: RetVal = Shell(CALC.EXE, 1) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Launch a program from Excel | Excel Programming | |||
script to launch a program from excel | Excel Discussion (Misc queries) | |||
Help: is it possible to launch acommand prompt shell and have commands piped into it? | Excel Programming | |||
Shell to another program from Excel | Excel Programming | |||
can vb from excel launch another program? | Excel Worksheet Functions |