vba to activate IE window and open file

orionsturtle

New member
Joined
May 28, 2019
Messages
3
Reaction score
0
Points
0
Excel Version(s)
2013 64bit
Hi. I pieced together some vba code in Excel that will open Internet Explorer, login to the site, navigate to a report and click on the link to download.
I am now staring at an open IE window with the classic IE bar at the bottom with the 3 buttons that have the choices "OPEN" "SAVE" "CANCEL".

The IE window title bar is grayed out (inactive...I assume). If I manually click the window, making the title bar blue and hit the Tab key and then the Enter key, the Excel report I am after opens.

I just need vba in Excel to do 3 things that have alluded me for several days now.
1.Activate the only instance of IE that is open.
2.Send a "Tab" keystroke.
3.Send an "Enter" keystroke.

I was looking at the following links from this forum:
https://www.excelguru.ca/content.ph...-Late-Binding-To-Connect-To-Internet-Explorer
https://www.excelguru.ca/content.ph...Late-Binding-To-Connect-To-Other-Applications

I could not get the code in these links to activate the IE instance I have open (make the title bar blue). It does return the location and name urls in the Immediate window.

If you have a good working knowledge of getting vba to interact with IE, I would appreciate any input to this solution.
Thank you!
 

Attachments

  • IE ScreenShot.PNG
    IE ScreenShot.PNG
    47.5 KB · Views: 18
Thanks for your reply. I'll check out the link.
 
Back
Top