I have an excel web query that grabs some data from the web and writes it to an external database. The query is set to refresh every 5 minutes. Works fine most of the time. Sometimes excel puts up an error dialog (unable to reach website...) and the query hangs up until this is acknowledged. I would like to automatically acknowledge as the intent is to have this query collect data periodically on a continuous basis. All the solutions I have seen regarding automatically handling dialog boxes require you to know when the dialog box is going to occur. This can run for days, sometimes I get the error several times a day. Appreciate any suggestion.
Phil B.
Phil B.