Deal with pop up box when downloading a file

[smiler44]

I think I'm struggling to find the right question to ask.
Following on from one of my previous threads.
Using the code below I can get to open Internet explorer and enter my url.
The actual url somehow causes a pop up box to appear with Save, Open and cancel buttons.
I am unable to simulate a click on the open button. it is either shift + O or ctrl + O I need to send.
I can not seem to send any key strokes to Internet Explorer either. The code below seems to give focus to explorer, I assume I need focus to be with excel and send to explorer but how??

Set IE = CreateObject("InternetExplorer.Application")
With IE
.navigate "url goes here"
.Visible = True
End With
Set IE = Nothing

spent hours during the day on this.
smiler44

 

[ratbags21]

Hi there,
I recreated your code (never done this before) and got my own website fine, no pop-ups or anything. However, my website is a learning thing and is totally simple. I guess the URL you are trying to launch is much more complex and it is clearly the website that is giving you a problem. I would be very surprised if you could communicate with the IE screen from Access, hence lack of respones from experts