| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ODBC parameter query fails with HAVING | Excel Discussion (Misc queries) | |||
| Query fails, requiring excel to be closed and restarted | Excel Programming | |||
| Macro query refresh fails | Excel Programming | |||
| Excel Query fails to include data? | Excel Programming | |||
| 1-variable Data Table dependent on MS Query fails to update correctly | Excel Discussion (Misc queries) | |||
Hybrid Mode
