View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JWM6 JWM6 is offline
external usenet poster
 
Posts: 1
Default How to start an application from Excel VBA


The VBA shell command is as follows:

programPath = "C:\Program Files\Internet Explorer\iexplore.exe" '
works
'programPath = "iexplore.exe" ' does not work
Shell programPath + " " + fileToLaunch, vbNormalFocus

but the drawback is that the invoked program (iexplore.exe, at least in
my case) needs to have the FULL PATH to where the program exists = the
"C:\Program Files\Internet Explorer" which may or may not work on
someone elses computer. Is there a trick to find where the executing
program lives? This hardcoding will not work and is not transportable.

Thanks,


--
JWM6
------------------------------------------------------------------------
JWM6's Profile: http://www.excelforum.com/member.php...o&userid=33413
View this thread: http://www.excelforum.com/showthread...hreadid=530730