[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2012-08-20
3
Medium Priority
?
452 Views
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 192.168.1.100 Command in DOS.  

Is there a way?
0
Comment
Question by:jkemp761
  • 2
3 Comments
 
LVL 24

Expert Comment

by:Steve
ID: 38313638
A tad slower as this has to ping twice... but this should put the hostname in the fist bit...
Ping-IP.xlsm
0
 

Author Comment

by:jkemp761
ID: 38315243
Error's out on:  Set tmpFileObj = FSObj.OpenTextFile(sFilename, 1)
0
 
LVL 24

Accepted Solution

by:
Steve earned 800 total points
ID: 38315950
I have modified the file a little.
All I can say is be patient with it, as it is not the fastest :(
Ping-IP.xlsm
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

864 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