Hi all,
I'm using the function "URLDownloadToFile"
which I found here:
This works well but in some very rare cases a web page cannot be downloaded and Excel simply hangs when executing the function for that web page. The function doesn't seem to have an option to abort trying to download the page if it doesnt work after an X number of seconds so the code will hang forever in that case.
A solution I could think of would be to build in a timer that would measure how long the URLDownloadToFile function is already attempting to download a certain page. Then if for example a 60 second limit is reached, I would want to force to abort carrying out the URLDownloadToFile function and resuming in another point of my code.
Is something like this possible?
thanks!
I'm using the function "URLDownloadToFile"
which I found here:
This works well but in some very rare cases a web page cannot be downloaded and Excel simply hangs when executing the function for that web page. The function doesn't seem to have an option to abort trying to download the page if it doesnt work after an X number of seconds so the code will hang forever in that case.
A solution I could think of would be to build in a timer that would measure how long the URLDownloadToFile function is already attempting to download a certain page. Then if for example a 60 second limit is reached, I would want to force to abort carrying out the URLDownloadToFile function and resuming in another point of my code.
Is something like this possible?
thanks!