Run time Error While Fetching Data Through Web Query

Hi,

I am using attached file for fetching data from 21 URLs through VBA code. Sometime it run successfully and generates the results and sometimes it randomly throws errors like, (1)We connected to the website, but didn’t receive any data from it. Error Code: INET_E_DATA_NOT_AVAILABLE (2) The connection to the website was reset. Error Code: INET_E_DOWNLOAD_FAILURE. This typically happens only with 4 URLs highlighted in yellow in attached file. When I open this pages in internet explorer 11, then also it randomly throws such error in only this 4 URLs. I have googled this issue and tried every possible solution, but still no success.

Can someone help me with some correction in VBA code such that when an error is reported, then the same URL is reattempted for at least 5 times and still error, then end macro or try next URL.

Some VBA code like, On Error.... Retry...

Thanks in Advance....

Hi !

Unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.