VBA Get Internet Connection Status Problem

[krm974ynk]

I have an issue, which I could not find a solution. I need a code to check the Internet availability and turn a result true or false. I have almost tried all the codes I found at internet. However I have a problem as follows:

When I disconnect LAN or WIFI the codes work fine. However in case either way the DSL line is down (If I turn off DSL modem or disconnect the line connection to DSL), or even If I connect wifi through a mobile phone Hotspot but turn off mobile connection (So there is no internet)

codes always turn to a true result. (They believe there is active internet)

So what could be wrong?

Thanks

[jmcilhinney]

Is this a VBA question or a VB.NET question? If it's the former, why is it posted in the VB.NET forum? If it's the latter, why does it say VBA in the title?

[westconn1]

So what could be wrong?

as you have not specified what codes you found on the net, hard to say, but most of the methods, while they say internet, it is really only checking if there is a network connection of any type, may have worked more correctly when internet was basically all dial up, but may still have been incorrect if there was a network connection as well as a dial up or using internet connection sharing

my best suggestion would be to ping your ISP or someother close server, to see if you get a valid response, if you are checking multiple connections your ISP may not be the best option, and you need to test the IP you choose is not set to ignore pings

[GBeats]

i just stumbles upon something that might be possible to use

Possibly something you can use

its running a ping using shell, now to automate this process your going to have to grab the window and check its contents, luckily ping writes the same thing, either ping failed or ping ping ping generally speaking, this method requires most likely using windows API if thats something your comfortable with. (its not hard really, lots of documentation out there)