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