Convert IP to Hostname

[gjandrews35]

I am looking for an Excel function/VB that
will take an IP and return a hostname and vice/versa.

Example
A1 216.45.19.33
B1 =nslookup(A1)

http://www.tek-tips.com

would be in Cell B1

A1

http://www.tek-tips.com

B1 =nslookup(A1) 216.45.19.33

 

[01Patrik]

Why don't you simply write a batch file with that content instead? I don't think it's possible to shell a batch file within an excel UDF, anyway.

// Patrik
______________________________

To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the IT Professional, the glass is twice as big as it needs to be.

 

[gjandrews35]

I didn't mean to imply I wanted to run the program
'nslookup'. I was just using that name as the name of a
possible function as an example ;-)

 

[fredericofonseca]

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q154512

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[fredericofonseca]

Sorry the above link is incomplete.

see

http://www.vbip.com/protocols/dns/vb-dns-tutorial-01.asp

and download

http://www.vbip.com/protocols/dns/dns-client-01.zip

for source code.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com