NSLookup host name to IP then ping results.

**Elkidogz** · 03-04-2013, 11:38 AM

So, here's my problem... I have several hundred host names which I have in an excel sheet, with the various server hardware information. I would like to resolve those host names into IP's then ping them, to include the response time, and status. I used a script I found on this site (see code snip below) to do the ping test, and I think it can provide the information I'd like to have

so what I'm looking for is This:

Column B has list of hosts
Column C IP
Column D Speed of response
Column E Status
Column F-aa (various server stats)

Please Login or Register  to view this content.

I'm not a programmer...

**Elkidogz** · 03-04-2013, 02:28 PM

This is closer but it's ending in a null value error

Please Login or Register  to view this content.

**Elkidogz** · 03-04-2013, 04:22 PM

[Solved]

buddy at work fixed it... here's the Code

Please Login or Register  to view this content.

**Rhudi** · 09-26-2013, 02:49 PM

This was helpful code. VERY HELPFUL. I had to hack a workaround to fit my needs, where I have a cell with an IP (not a host name) and I just needed to ping the IP found within the current cell. THANK YOU!