When creating a spreadsheet that connects to the internet, possibly a web service or sending emails, it might be a good idea to test for an internet connection before connecting.

This could prevent a user from getting annoying error messages or having the application just sit there.

While I don’t usually follow this advice, I have been looking into it and found a short script that has been working nicely for me.

The wonderful script is buried at Ron de Bruin’s site. You can find it by visiting Ron’s Tips page then scrolling down a ways, and it’s also archived in the newsgroups over here.

Definitely one to bookmark.