Pinging IP Address - Excel Form

[Disturbedguy]

Hi all,

Hoping for some quick help.

I have a form that will list an router IP address (The IP is in a label).

I know there are ways to ping an IP address that is within a cell in Excel, however I was wondering if it was possible, to have it so I click a button and it pings an IP address.

The only way I can think of doing it, is that in the code assigned to the button, the IP address is there and then when pressing the button it launches command prompt and pings the IP address.

Does anyone know how to do this / weather its possible?

Thanks in advance for replies.

[TheAnimus]

Easy, do it all in VBA. Shelling the command prompt is nasty.

http://social.technet.microsoft.com/...m-vba-in-excel

Has an example using WMI.

You could take the example they have, and make it use an input from a cell or similar, if you do use a Cell set it to a Named Range.

[TheAnimus]

Also to add, if its not on the domain and you can't use WMI, the much more fun way with winsock:
http://www.vbaexpress.com/forum/arch...hp/t-5233.html

[Disturbedguy]

Thanks Animus.

Call me stupid but I can't see how to use this? (I'm not much of a code monkey, only had limited experience / exposure)

[Disturbedguy]

Ok, I've managed to get something working, slightly different then what I wanted but its somewhat working.
It displays the response times and the bytes but it doesnt seem to display the TTL which I would like it to, ive had a quick look but can't see how to / if its possible to display the TTL.

I am using the last suggestion

Edit - Maybe its not working how I want it to, I want it to ping (if possible) how it would if I were doing it from command prompt. However the one I am using, however pings based on what I put in a text box, so as an example if I ping with the data test, I am told the packet size is 4 bytes (obviously) and it gives me the MS too.

[TheAnimus]

Well ping is really an ICMP Echo request, the other person replies with a 'pong' the same data to detect corruption. As ICMP is lower level protocol than TCP/IP it is very possible for it to be a corrupt response that you get back (garbaled response).

You can just create a string with the Space function.

So you can take the code that reads the textbox, and use Space(512) if you want instead.

[Disturbedguy]

Well ping is really an ICMP Echo request, the other person replies with a 'pong' the same data to detect corruption. As ICMP is lower level protocol than TCP/IP it is very possible for it to be a corrupt response that you get back (garbaled response).

- Thanks this makes sense.

You can just create a string with the Space function.

So you can take the code that reads the textbox, and use Space(512) if you want instead.

Not quite sure what you mean by this. But I guess if I just want to test if something (in this case a router) is receiving a ping or not, then what I have at the moment is doing the job.

[Splash]

I'd be interested to know why you're wanting to do this from a spreadsheet. I'm sure there's a reason, but checking a router is up is the job of your network monitoring software (and surely you have something there if you're still working at the same please?) - this kind of data should be automated and logged to a database, generating relevant alerts for exceptions.

[Disturbedguy]

I'd be interested to know why you're wanting to do this from a spreadsheet. I'm sure there's a reason, but checking a router is up is the job of your network monitoring software (and surely you have something there if you're still working at the same please?) - this kind of data should be automated and logged to a database, generating relevant alerts for exceptions.

Nope, not working at the same place any more, had a new job for just about a month now and thus far I haven't seen any network monitoring software, unless I just haven't been introduced to it.

Basically we have a number of depots across the UK, so I was wanting to come up with something pretty basic, that we can use to ping to ping routers, without having to search for the IP address would be advantageous and quicker.

Will likely hold other information too, but it's just an idea at the moment.

[wasabi]

This looks ready made for what you want to do if you can get $35 signed off....
http://www.checkthenetwork.com/iptoolsforExcel1.asp