Boolean function to return whether the PC is connected to the Internet?

I want a boolean function to return whether the PC is connected to the Internet. I have no idea how to start creating this. Could anyone please provide please?


Reason:
I have code that checks an online database and downloads data after the user presses a button.
If the host computer is not currently connected to the net, I would like to display a message of my choice instead of trying to run the code.
To determine whether to run my message or not, I need a function that will return TRUE/FALSE if the host PC is net connected or not.

+1 for trying. I'm afraid that this code isn't working for me. I keep getting a result of not connected. I think the problem could be to do with corporate restrictions on the computer I am testing this on. So I think I will need a solution that doesn't rely on the use of windows script or cmd. (Also the code takes 20 seconds to run so I will need a faster alternative solution).

Originally Posted by xLJer

If the PC is connected to the internet, you should see a line that
contains the text "Reveived = 4". If not, then that would explain
why my code did not work.

Confirmed I got "received = 4"

Well done xlJer +1

Dropping the first letter causes the function to work correctly.

Originally Posted by Kyle123

How are you connecting to the database?

XMLHTTP (Microsoft XML tool reference required)

Originally Posted by Kyle123

The problem with just checking with internet connectivity is that you are only checking half the path. You could be connected to the internet, but the remote database could be offline - so you need to check both.

I agree that what you are saying is 100% correct.
However, for the purpose of this thread, I am not worried about the database going down. I am more concerned about the more common occurence of an end user using the XLSM and not realising that they need to be internet connected. So I am looking for a function that efficiently determines this so I can then show a reminder message to the end user.

xLJer has provided a working solution however a

Please Login or Register  to view this content.

before & after running the code confirms that it is taking 19 seconds to run on the end user machines. (Probably because of excess corporate filtering and/or aggressive anti-virus ). Since I can't change the end users machines, I am looking for a much faster alternative to determine internet connectivity.

However, for the purpose of this thread, I am not worried about the database going down. I am more concerned about the more common occurence of an end user using the XLSM and not realising that they need to be internet connected. So I am looking for a function that efficiently determines this so I can then show a reminder message to the end user.

But tbh that only does solve half the problem, it's faster just to xml the data base, if it's there, the user is connected to the database AND the database is up. In your scenario, what happens if they are connected to the internet, but cannot connect to the database?

If all you want to do is check internet connectivity, I'd hit google

Solved!

+ = fast
- = requires reference library (Microsoft XML)