DNS Lookup through XLS VB

March 25, 2009 at 12:27:16
Specs: Windows XP
Can somebody assist me in write a vb scrip... I have an XLS sheet with a list of 500 hostnames that I need to find th IP address for. So basically look at the hostname in A2, do a dns look up and add the IP addy in B2, then repeat through the list... I know that I have written something simular too many years ago to remember how....

See More: DNS Lookup through XLS VB

Report •

March 25, 2009 at 13:46:14
I don't think you can do so with VBScript. I wrote a VBA class module years ago for something similar, but I had to use the Win32 API to do it.

Report •

March 26, 2009 at 00:36:21
ping??? i think it's in wsh.network.

Pinging www.l.google.com [] with 32 bytes of data:

Report •

Related Solutions

Ask Question