• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

Get IP address and host name from excal file

I had a list of urls in excel file. how can I get IP addresses and host name from this urls ?
0
HLUSUNSEN
Asked:
HLUSUNSEN
1 Solution
 
JohnBusiness Consultant (Owner)Commented:
Taken at face value, they are just URL's so will not have IP addresses in them. IP addresses are resolved after the URL is activated.

You need to activate the URL in a browser window, and from there, you could do a lookup on the name to get an IP address.  ... Thinkpads_User
0
 
AntonInfCommented:
i guess one manuall way is to just ping the url and get the ip address for each one..

but that might take a while...
0
 
HLUSUNSENAuthor Commented:
Instead of manually sort them out, is that possible to run a VB script in excel file and get answer? Can anyone supply me a VB script for this ?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
JohnBusiness Consultant (Owner)Commented:
A URL is a locator to *find* the IP address. So it would have to a fairly complete "whois" lookup VB script to do such a thing. ... Thinkpads_User
0
 
m4trixCommented:
I adapted the code from here:
http://www.breakingpar.com/bkp/home.nsf/0/87256B280015193F87256CA300788B6E
and it works perfectly.  I have to give full credit to the author from that site.

iplookup.xlsm
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now