Nslookup in excel

[Steffmeister]

Hi everybody,

I've got a question about nslookup in Excel.
I've got 1 column (A) with IP-addresses and I want to have a hostname of it. In cmd I can fill in nslookup xxx.xxx.xxx.xxx but that is too much work for me, because it is a lot of addresses. Is it possible that Excel can get a range of addresses with hostname via nslookup? The results must come in Sheet 2 if that is possible?
Does anybody have a VBA code for this?

Tnx for now,
Steffmeister

 

[Steffmeister]

I tried to export the xls file to a .txt file and fill in the command
nslookup filename.txt Output.txt
But this doesn't work. Can somebody plz help me? I prefer to have the results in Excel.

Grts Steffmeister

 

[Steffmeister]

Nobody can tell me if this is possible or help me with a macro?

Greets

 

[Steffmeister]

I can't find something about command nslookup in VBA. Could somebody help me to find something about this, how I can do it?

Grts. Steffmeister