Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Get IP address and host name from excal file

Posted on 2011-09-13
7
Medium Priority
?
289 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 97

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
Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
LVL 97

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 2000 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
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

722 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