QueryTables Interrupt if URL is Down

S

Steve Hieb

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top