Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

DNS Lookup through XLS VB

Comment:

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....

Name: Razor2.3
Date: March 25, 2009 at 13:46:14 Pacific

Reply:

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.

0

Name: reno
Date: March 26, 2009 at 00:36:21 Pacific

Reply:

ping??? i think it's in wsh.network. Pinging www.l.google.com [209.85.143.104] with 32 bytes of data:

0

Batch Job to Copy folders...

schedule incremental inst...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi, ive setup a vpn server and want to write a vb app to connect to the vpn server, not using dial-up, but using an existing internet connection. I have had no luck in finding any info on connecting t...

Summary: I'm not sure if WinXP's DNS API supports NetBIOS names, but you can try it: 'DNS Lookup Declare Function DnsQuery Lib "dnsapi.dll" Alias "DnsQuery_A" _ (ByVal sName As String, _ By...

Summary: hey all, got a question please: what can cause your VB to crash? I am working on a program... and as you might have read my previous post, i was successfull in getting the tabdock control to work. bef...