Using VBA to produce output from NSLOOKUP
Posted on 2006-11-03
I'm trying to use a command button in MS Access (as I don't have VB installed at work) to do the following:
1. Open a text file containing IP Addresses
2. Run NSLOOKUP (an executable that displays info for each IP address on screen) against each IP address
3. Print the returned info for each IP Address to a new text file and do this until reaching the end of the IP Address file.
I'm familiar with how to open a file for input and output, but not with how to run the NSLOOKUP from code or how to print the output of the NSLOOKUP to a new text file.
Any help is appreciated.