Menu
I'michael functioning with a good measured spreadsheet of websites and machine names. Another consumer of the spreadsheet wants the IP tackle for each of the DNS items on the worksheet. Rather of manually incorporating and after that having to preserve this list, is presently there an simple method to do an IPAddress lookup to display the IP address in a mobile?
I've observed some VBScripts that contact GetHostByName, age.gary the gadget guy.
Sep 22, 2011 Re: Excel and NSLOOKUP My apologies for not being clearer in my initial request. NSLOOKUP is a command line program (MS Windows) to return information from an IP address. The syntax for the LOOKUP function in Microsoft Excel is: LOOKUP( value, array ) Parameters or Arguments value The value to search for in the array. The values must be in ascending order. Array An array of values that contains both the values to search for and return.
Nevertheless I'm not really a VB specialist so I'm not sure if this is the right way to move.
Gaff16.1k1111 money badges4949 silver precious metal badges6464 bronze badges
Kevin WilliamsKevin Williams
1 Response
Try out visiting this site. Possibly you'll need to adapt more than on script to fit all your requirements.
For instance, this script will get the IPs for an whole DNS server. You could adapt it stroll an excel spreadsheet and retrieve simply the types that you need.
Chad RiversFrank Streams49022 gold badges66 metallic badges1313 bronze badges