Alternative to Application.Wait vba

Hello,

I have a code that downloads files by looping into a listed links. The sequence of downloading the files is very important(the codes download the file based on the arrangement of the list) and the there were instances that a file is not downloaded on time becuase of its size or the slowness of the connection. Hence, I have to rerun the code to start over again. To address this, I included Application.wait to 10 seconds before it download the next file. But there be an alternative code that would wait for the file to completw to be downloaded first before downloading the next file? Thanks

.
I suspect you are using the following, which is what I use here :

Please Login or Register  to view this content.

Works very well.

Can’t you use doevents in a loop whilst checking for the file as Trevor suggests?

Originally Posted by Logit

.
I suspect you are using the following, which is what I use here :

Please Login or Register  to view this content.

Works very well.

Yes this is what i use and works well. I set it to 10 sec to ensure it doesnt skip any files. However, takes a lot of time to compelete the downloads especially im downloading 50+ files.

Originally Posted by Kyle123

Can’t you use doevents in a loop whilst checking for the file as Trevor suggests?

I rely on the sequence of of downloading because I don't know the filenames of each file. The link itself doenst give you the filename. When the file is downloaded, it gives me a ranfom filename. Completing all the download,I also run another code to rename the filenames based on the list as well.

I think we need to see some code, please post what you are using