Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Interrupt find and replace Richard Excel Worksheet Functions 1 October 18th 05 01:32 AM
Excel compare workbooks: need to interrupt and resume sync scroll Al in Ladner Excel Discussion (Misc queries) 0 June 14th 05 07:25 PM
Message box that does not interrupt code Claude Excel Programming 2 October 10th 03 04:12 PM
how to prevent user to interrupt macro Jerome LT Excel Programming 2 August 13th 03 10:28 AM


All times are GMT +1. The time now is 06:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"