call external function
How do I convert a column of IP addresses to resolved DNS names (eg using the
Windows command line function nslookup() - I wonder why this isn't a standard Excel function, with optional parameters, such as named DNS server etc)? |
call external function
Dear David
There is no built-in function; however you can use nslookup within a macro to get this done. Refer http://tools-utils.com/snippets/dnsrecords.html If this post helps click Yes --------------- Jacob Skaria |
call external function
Thanks - I suspected I might have to do this, but was having difficulty
finding any hints or tips. "Jacob Skaria" wrote: Dear David There is no built-in function; however you can use nslookup within a macro to get this done. Refer http://tools-utils.com/snippets/dnsrecords.html If this post helps click Yes --------------- Jacob Skaria |
All times are GMT +1. The time now is 04:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com