View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default VBA shell command - issues...

Try

Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
MsgBox IE.FullName
IE.Quit
Set IE = Nothing


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"JWM6" wrote
in message
...

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. This hardcoding will not work and is
not
transportable.

Is there a trick to find where the executing program lives? or
launching it without the path?

Thanks,


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