I'd try a combination of the Application.Wait and a loop to check to see if the
download file is ready.
Depending on file size, I'd probably check the size of the download file.
then wait for 5 seconds, and check again.
If the file size changes, then wait again until the file size no longer
Did you try below code for waiting browser.
Do while browser.busy or browser.readystateREADYSTATE_COMPLETE
Doevent
loop
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Sukanta Datta
Sent: Tuesday, June 10, 2014 7:39 PM
To: