Thursday, February 2, 2012

Excel document for pinging list of computers VBA

Here is an excel document I created that will ping a list of nodes in column A and give results in column B. There are much better tools that can be used such as angry ip scanner http://www.angryip.org/w/Home. I just wrote this as an example



Requirements:
Tested with Office 2010

Download:
Download

10 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. I'm having trouble with false positive results. When I run the script it shows some devices as "On Line", however when I manually ping it, the response is "Reply from XXX.XXX.XXX.XXX: Destination host unreachable.". I'm not sure how to fix this as I'm no good at VBA.

    ReplyDelete
  3. I updated the excel doc can you try the new one. Let me know

    ReplyDelete
  4. This is great! Thank you :)

    ReplyDelete
  5. Sounds like it could be of a bit of use, but the file is no longer available in your dropbox.

    ReplyDelete
  6. The link still seems to work maybe your browser or something else is block it since it is an xlsm

    ReplyDelete
  7. This helped a lot, Now I can do something with this.

    ReplyDelete
  8. Fax services are essential in industries that require immediate document verification.
    Fax Services Master

    ReplyDelete
  9. IsraFace - еврейский сайт знакомств, это еврейская социальная сеть, где знакомятся еврейки и евреи и русский еврей из Украины и России. Показывайте лучшие фото, записи, подключайтесь в группы, открывайте блог, заходите на форум, устанавливайте еврейские знакомства.

    ReplyDelete