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,
|