View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] spareus@walla.com is offline
external usenet poster
 
Posts: 2
Default How to detect Internet connection

Sir,
I am automating our daily report to be sent by email thru excel VBA.
I have the code and is working fine. The only problem is with internet
connection. If the connection is not available when the macro runs, the
macro simply fails.
Is there any way, by which I can detect programmatically, if internet
connection is available or not? If I can detect it, I can simply put it
in a loop and send the mail when it is available. With this final step,
I can completly eliminate any human interaction to get reports.

Any directiopns will be appreciated.
Regards,