ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   QueryTables Interrupt if URL is Down (https://www.excelbanter.com/excel-programming/282804-querytables-interrupt-if-url-down.html)

Steve Hieb

QueryTables Interrupt if URL is Down
 
I know I can use the xlErrorHandler property of EnableCancelKey to
provide an interruption mechanism. However, there are several reasons
why I'd prefer to simply abort the query if the URL has not responded
after X seconds. I could use Application.OnTime or similar if this
was a loop, but I can't figure out how to execute a wait when calling
an http.

TIA,
Steve Hieb


All times are GMT +1. The time now is 12:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com