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,

Hi Amedee,
Thanks for your response.
I got what I want.

I seen some surprise in your post.
Note: The author of this message requested that it not be archived.
This message will be removed from Groups in 6 days (Apr 18, 7:36 am).

I have never requested to remove my post or not to archive. Then why
this message?

Moreover, I have read about headers of the message posted over here.
Looking at message headers will tell you lot of things etc etc.
What is it? I am using browser to read and post messages. Is it
possible to see headers with browser? What informations are available
in these mysterious headers and where exactly these headers are
located? What is the way or URL of headers?
I hope I am not boaring you with my funny/foolish questions. Infact it
is only my curiosity to know. Thats all.

THANK YOU ONCE AGAIN.
Have a nice day.



Amedee Van Gasse wrote:
shared this with us in
microsoft.public.excel.programming:

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,

Google is your friend!
http://www.google.com/search?q=vba+c...net+connection
The first link gives you exactly what you need:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=313
This one may also work:
http://www.developerfusion.com/show/3903/

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way
http://www.catb.org/~esr/faqs/smart-questions.html
How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as
the
answer.

http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
o-answers.html