Solved

Get IP address and host name from excal file

Posted on 2011-09-13
7
281 Views
Last Modified: 2012-06-27
I had a list of urls in excel file. how can I get IP addresses and host name from this urls ?
0
Comment
Question by:HLUSUNSEN
7 Comments
 
LVL 90

Expert Comment

by:John Hurst
ID: 36532763
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
 
LVL 2

Expert Comment

by:AntonInf
ID: 36532777
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
 

Author Comment

by:HLUSUNSEN
ID: 36533020
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 90

Expert Comment

by:John Hurst
ID: 36533081
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
 
LVL 7

Accepted Solution

by:
m4trix earned 500 total points
ID: 36533191
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
 
LVL 50

Expert Comment

by:teylyn
ID: 37087217
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

706 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

18 Experts available now in Live!

Get 1:1 Help Now