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