Excel and NSLOOKUP

[eric7753]

My initial goal is to use the command NSLOOKUP via Excel and VBA. In column A I will have a list of IP addresses in xxx.xxx.xxx.xxx format and would like to create a macro that can call NSLOOKUP and report the results of the lookup in the corresponding cell in column B.
Example:
A1 B1
192.168.101.154 myhomecomputer.domain.com

I have found several scripts that come close to this request, but don’t quite complete the task. Does anyone have a script in their bag of tricks they could share?
I am using windows XP, Excel 2007, and am on a domain.

 

[tuffluck]

i don't know what nslookup is, but why not just use vlookup?

 

[MrKowz]

Welcome to the forums!

As tuffluck says, what you want is VLOOKUP.

The way you call this in a macro is Application.WorksheetFunctions.VLOOKUP(*value to look up*, *range to look in*, *column to return*, *true/false*)

 

[eric7753]

My apologies for not being clearer in my initial request. NSLOOKUP is a command line program (MS Windows) to return information from an IP address. I found a rather old request for the same request, but there were no responces.


http://www.mrexcel.com/forum/showthread.php?t=171977&highlight=nslookup

 

[John_w]

Post your best attempt and maybe someone can help to tweak the script.

Also, why do you need NSLOOKUP? Couldn't you use Ping instead?

 

[coaxial]

Not meaning to dig up an old post. But I was just looking into this same question and I found a solution. It was helpful enough that I even made an account here! Take a look at this blog post.

http://jayteknews.blogspot.com/2011/08/excel-user-defined-function-nslookup.html

Enjoy