Updated PingCell Function for Excel

This post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author.

I’ve updated my Microsoft Excel PingCell code that I published previously. The new function returns all results from Win32_PingStatus back to Excel. You can now ping and choose the results you’d like to see returned (example below code). The Win32_PingStatus class is documented on Microsoft’s Website.

To restrict the results returned to just what you want, modify the rows where Cells(r.row, column+n) are set. For example, to return just the status and the IP Address, you’d remove all except for these two:

You can then change the column+4 to column+1 so that they sit next to each other.


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.