Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
error handling off?? | Excel Programming | |||
Error handling | Excel Programming | |||
Error Handling | Excel Programming | |||
Error handling | Excel Programming | |||
Error handling | Excel Programming |