![]() |
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