Automatically clear web query message "unable to open http:"
 

I am using a web inquiry to bring information into an excel spread sheet. A
Macro performs the web query at regular intervals throughout the day.
Occassionally Excel sends a message stating that it was "unablet to open the
http:// . . . ". This stops the macro and prevents it from getting
information for the rest of the day.

How can I automatically clear this excel message using VBA code or another
method?

Automatically clear web query message "unable to open http:"
 

I don't have enough information to help without seeing the macro. Question,
if you exit the workbook and reopen does the macro work?

You may have the statement Application.EnableEvents = False which will stop
new events from occuring.

You can put a simple macro to solve this problem

Sub EnableEvents()

Application.EnableEvents = True

end Sub

I don't know what mechanism is being used to perform the query at regular
intervals. The macro may be using TEMP files on your computer to determine
when to run the query. I can't tell without seeing the code.


"Greg" wrote:

I am using a web inquiry to bring information into an excel spread sheet. A
Macro performs the web query at regular intervals throughout the day.
Occassionally Excel sends a message stating that it was "unablet to open the
http:// . . . ". This stops the macro and prevents it from getting
information for the rest of the day.

How can I automatically clear this excel message using VBA code or another
method?