View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nil nil is offline
external usenet poster
 
Posts: 1
Default dialog box displayed when internet connection unavailable

help! i am building a system which uses web queries to import data fro
the internet. when i open the file, and there is no internet connectio
(i am on dial up) i am bombarded with dialogs telling me the site wa
unavailable, is there any code which i can input into my auto_ope
which will disable these message boxes, i have already tried

application.displayalerts = false

and

application.autoresponse

but that is only available in excel 2000.

Has ANYONE got any suggestions out there???
thanks in advance

nilz

--
Message posted from http://www.ExcelForum.com