Results 1 to 3 of 3

Thread: vba to activate IE window and open file

  1. #1
    Neophyte orionsturtle's Avatar
    Join Date
    May 2019
    Posts
    3
    Articles
    0
    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:
    https://www.excelguru.ca/content.php...ernet-Explorer
    https://www.excelguru.ca/content.php...r-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!
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

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

  2. #2
    Seeker Smarter's Avatar
    Join Date
    Aug 2019
    Posts
    7
    Articles
    0
    Excel Version
    2007
    i am just learning as well

    you can find the required info here. it will work after many many round of testing and configuration
    not sure if your window version / ie version will have impact
    it's tested to work under win7 and win 10

    https://stackoverflow.com/questions/...plorer-save-as

  3. #3
    Neophyte orionsturtle's Avatar
    Join Date
    May 2019
    Posts
    3
    Articles
    0
    Excel Version
    2013 64bit
    Thanks for your reply. I'll check out the link.

Posting Permissions

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