View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bruce Bruce is offline
external usenet poster
 
Posts: 138
Default 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