Shell Command to open Internet Explorer only site generates errors: Invalid argument or file not found

Question

I'm trying to open Internet Explorer for a specific IE only site.

Depending on the amount of quotes I get

invalid argument

or

file not found

Disclaimer:
Ignore any out of place spaces and capital letters. I can't copy paste my code since my PC has no internet connection and is inside a virtual machine at work. I'm typing this on my phone.

On cmd

%program files%\internet explorer/iexplore.exe -private myurl

works fine

On Excel, Shell commands throws a error file not found

URL = "%program files%\internet explorer/iexplore.exe -private myurl" 
Shell """" & URL & """"

Tim Williams · Answer 1 · 2019-04-26T18:05:25.580

0

Try:

Shell Environ("ProgramFiles") & _
      "\internet explorer\iexplore.exe -private http://www.google.com"

edited Apr 26 '19 at 18:05

answered Apr 26 '19 at 17:48

Tim Williams

154,628
8
97
125

https://stackoverflow.com/questions/8701967/get-path-of-program-files-folder-that-contains-32-bit-programs – Tim Williams Apr 26 '19 at 18:06
The path is correct I copy pasted the ie location to vba however I still tried this same error file not found – Aeon Apr 26 '19 at 18:26
With the space in "program files"? In any case - seems like you cannot use that via Shell – Tim Williams Apr 26 '19 at 19:55

Aeon · Accepted Answer · 2019-05-04T15:40:32.130

-1

Okay so I found the correct way to open internet explorer in vba here it is

Sub openie ()

Dim iebrowser as object

set iebrowser = createobject("InternetExplorer.Application")

iebrowser.visible =true iebrowser.Navigate2 "www.google.pt"

End sub

edited May 04 '19 at 15:40

answered May 04 '19 at 11:33

Aeon

87
10

Shell Command to open Internet Explorer only site generates errors: Invalid argument or file not found

2 Answers2