How to Pause Script While Internet Explorer Downloads File

All,

I'm having some difficulty with the following. I have a script that will automate internet explorer to download a csv from a website (by clicking an "export" button on the IE webpage). I need to be able to pause my code until the yellow "Open/Save" bar at the bottom of the page appears.

Any ideas here?

See VBA Wait method or Sleep from a Windows dll or via UIAutomationClient or …

But better than piloting IE is to directly use a web request (the same use by webbrowsers) when possible.

Hi Marc,

The workbook in question is planned to be sent out to ~30 end-users (Excel 2013 and up, 32 & 64 bit machines). Do you think integrating windows dll or UIAutomationClient would result in errors? Admittedly, i'm not as experienced in this realm of vba. I'd like to learn more about the direct web requests via vba as well.

To this point, i've been unable to pin down the URL of the download too...it's simply a button on a web-page. I wish I could shoot over the page, but there are privacy issues..

As a work around i've been using ie.busy functions followed by the VBA wait method. Then sendkeying ctrl+j to the IE window to download the file to the machine...clunky I know..

Any guidance that you could offer would be really appreciated!

Originally Posted by ChrisHook

The workbook in question is planned to be sent out to ~30 end-users (Excel 2013 and up, 32 & 64 bit machines). Do you think integrating windows dll or UIAutomationClient would result in errors?

Could be as I already saw a working code piloting IE on some computers but failing on another (nothing to do with 64 bit)
as it may depend on IE & Windows version …
Guidance is difficult as piloting IE is specific to each webpage, as we can't guess …
So first try with Wait method and search on web VBA samples.