When a web query fails.
 

I have an Excel 2007 spreadsheet that periodically does web queries during
the day. If a query fails because of a problem on the web a Microsoft Office
Excel dialog box pops up advising that the query failed. How can I handle
this? Simplistic Error Handeling techniques (On Error Resume Next, On Error
GOTO ) do not work.
--
Thanks
Bruce

When a web query fails.
 

not really experienced in queries, but would application.display alerts = false
work? just thawing that out.

--


Gary


"Bruce" wrote in message
...
I have an Excel 2007 spreadsheet that periodically does web queries during
the day. If a query fails because of a problem on the web a Microsoft Office
Excel dialog box pops up advising that the query failed. How can I handle
this? Simplistic Error Handeling techniques (On Error Resume Next, On Error
GOTO ) do not work.
--
Thanks
Bruce

When a web query fails.
 

Sorry, I should have said, Application.DisplayAlerts = False also has no
effect. I wonder if it is somthing to do with WindowsXP sending Excel a
message?
--
Thanks
Bruce


"Bruce" wrote:

I have an Excel 2007 spreadsheet that periodically does web queries during
the day. If a query fails because of a problem on the web a Microsoft Office
Excel dialog box pops up advising that the query failed. How can I handle
this? Simplistic Error Handeling techniques (On Error Resume Next, On Error
GOTO ) do not work.
--
Thanks
Bruce