How Can I ping IP's in Excel and Return Hostnames

Posted on 2012-08-20
Last Modified: 2012-08-22
How Can I ping IP's in Excel and Return Hostnames:

Currently I have an Excel with a Macro that Barman helped me with that Pings a Column of IP's in Column D and Puts them in Column J.  In Column I id like to put the hostname that IP is responding to.  Kind of Like a Ping -a Command in DOS.  

Is there a way?
Question by:jkemp761
    LVL 24

    Expert Comment

    A tad slower as this has to ping twice... but this should put the hostname in the fist bit...

    Author Comment

    Error's out on:  Set tmpFileObj = FSObj.OpenTextFile(sFilename, 1)
    LVL 24

    Accepted Solution

    I have modified the file a little.
    All I can say is be patient with it, as it is not the fastest :(

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now