Ping continuously multiple IP's from a column - VBA code?

[alinpion]

Hello!

I want to create a excel file with VBA code that ping's the IP's from column A, give a response to column B (OK or NOT OK) and in column C gives the last "OK" ping date and time.
Something like:

      A                 B                C
194.154.200.10         OK           14/04/2013 13:10
194.154.200.11      NOT OK       14/04/2013 13:00
194.154.200.12         OK           14/04/2013 13:10

The ping process should be a continuous loop.

What I found this far involved text files and I don't want that.

 

[daverunt]

Hi,

Not exactly what you want but it might give you some pointers.

Solved: VBA - Excel - XP - Ping - VBA Express Forum

 

[excel_tools1]

Hello,

There is a tool for this. To ping in Excel you should check out IP Tools for Excel. Link: IP Tools for Excel - Check The Network

Hello!

I want to create a excel file with VBA code that ping's the IP's from column A, give a response to column B (OK or NOT OK) and in column C gives the last "OK" ping date and time.
Something like:

      A                 B                C
194.154.200.10         OK           14/04/2013 13:10
194.154.200.11      NOT OK       14/04/2013 13:00
194.154.200.12         OK           14/04/2013 13:10

The ping process should be a continuous loop.

What I found this far involved text files and I don't want that.

 

[Kulasekararaja]

Hello Friend,

Hope this easy tool can help you for this.

PingInfoView - Ping to multiple host names/IP addresses

Thanks.

 

[xchaparro]

Hello Friend,

Hope this easy tool can help you for this.

PingInfoView - Ping to multiple host names/IP addresses

Thanks.

This tool is great, so easy to ping directly from excel

Check The Network - IP Tools for Excel Features Overview