When a web query fails.

G

Guest

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.
 
G

Gary Keramidas

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

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why do I have to restart Excel when ActiveSheet.QueryTables.Add fails? 2
Invalid Web Query Error 6
ActiveWorkbook.RefreshAll Problem 0
VB scripped works in Excel 2003 but fails in 2007 2
Excel Web Query 1
Excel 2007 data query parameter issue 6
MS Query problem 2
Query fails, requiring excel to be closed and restarted 1

Top