View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Lawson[_4_] Matt Lawson[_4_] is offline
external usenet poster
 
Posts: 9
Default Error Handling with Web Queries

I have a program that collects data from web queries (the filename of the
webquery changes every hour, I use ontime on 5 minute intervals to always get
the newest data from the newest hour.)

Anyway, there's always a chance on the overlap that the new hour may not
have been generated yet. As such, occassionally the webquery will report:

"Connection was available but no data was there"

The problem with this is that it locks excel until someone clicks ok (ie the
timer will no longer run). Is there anyway I can disable the message from
appearing, or atleast not lock the program?

Using on error resume next or on error resume 0 in the procedure does not
seem to help.

Any ideas?

Thanks again

Matt Lawson