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:

15 comments:

  1. good work ¡¡¡¡¡ congratsssss

    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. This comment has been removed by a blog administrator.

    ReplyDelete
  9. Indeed, in a few cases this has proved correct and I am led to believe that some organisations have managed to go paperless, however, I am yet to find one of these organisations.document scanning services

    ReplyDelete
  10. I started building computers around 1996, when I was ten years old, and it became a hobby of mine which led into a business about 16 months ago.10 Best Computers For College Student in 2019

    ReplyDelete
  11. Of course you have to be careful and not force components in spots they do not belong, but it is difficult to mix up as most things can only go one way, and will only fit in the correct location.reset windows 10 password

    ReplyDelete
  12. For those that don't want to think too much they may use these interfaces as communication tools for thought-swapping in a social networking type system human computer interaction Techpally

    ReplyDelete
  13. So, it is recommended that a computer should contain minimum of 1 GB memory for the latest updates of software.https://www.buzzbeasts.com/computer/all-in-one/

    ReplyDelete
  14. The idea on how the algorithm of a computer does its arithmetic was based on this, in logic. Soon after, for as early as 1820's, in the personification of Charles Babbage, dubbed to be one of the fathers of modern computer, developed ideas on how computers should do its math, initially known as the difference engine, it developed later after to become what is known as the analytical engine. https://www.desktopcon.org/best-computer-for-college-student/

    ReplyDelete