How to lookup an IP address in an Excel spreadsheet?

Question

I'm working with a decent sized spreadsheet of domains and server names. Another user of the spreadsheet needs the IP address for each of the DNS entries on the worksheet. Instead of manually adding and then having to maintain this list, is there an easy way to do an IPAddress lookup to display the IP address in a cell?

I've seen some VBScripts that call GetHostByName, e.g.

Declare Function GetHostByName Lib "wsock32.dll" Alias "gethostbyname" (ByVal Host As String) As Long

However I'm not a VB expert so I'm not sure if this is the right way to go.

Answer 1

Try visiting this site. Probably you'll need to adapt more than on script to fit all your needs.

For instance, this script will retrieve the IPs for an entire DNS server. You could adapt it walk an excel spreadsheet and retrieve just the ones that you need.