Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Queries - bypassing "no connection / data available" messages.
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. Or perhaps the website isn't working moementarily. As such, occassionally the webquery will report: "Connection was available but no data was there" or "No response from connection" 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. Application.DisplayAlerts = False also doesn't help. My conclusion is as such: This isn't a normal runtime error, nor an application alert? Any other ideas? Thanks again Matt Lawson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting "file corrupted" messages, started recently. | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Parameters In External ODBC Data Queries - "is one of" | Excel Discussion (Misc queries) | |||
vba weird messages - "catastrophic failure" | Excel Programming | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |