• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • 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
 
John HurstBusiness 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
John HurstBusiness 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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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