Results 1 to 1 of 1

Thread: vba to activate IE window and open file

  1. #1
    Neophyte orionsturtle's Avatar
    Join Date
    May 2019
    Excel Version
    2013 64bit

    vba to activate IE window and open file

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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:

    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!
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	IE ScreenShot.PNG 
Views:	6 
Size:	47.5 KB 
ID:	9132  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts