Im using a web query to import data from a website using searched terms from Excel into a worksheet.
So column A contains my search terms and column B contains the found result from the page.
I have this working in VBA perfectly fine as loop through column A.
However the reason I am asking is because sometimes the Internet connection drops and Excel hangs/crashes whilst connecting or retrieving web site data.
After some time spent googling I have found that I need to use either Application.OnTime or Application.Wait to add a timeout. The problem is, I haven't a clue how.
So column A contains my search terms and column B contains the found result from the page.
I have this working in VBA perfectly fine as loop through column A.
However the reason I am asking is because sometimes the Internet connection drops and Excel hangs/crashes whilst connecting or retrieving web site data.
After some time spent googling I have found that I need to use either Application.OnTime or Application.Wait to add a timeout. The problem is, I haven't a clue how.