PDA

View Full Version : Hostname to IP



kevinpope
07-18-2013, 02:09 PM
Is it possible to perform the following in Excel 2010:

User enters a hostname in cell A2
Cell A3 would then return the IP of the hostname entered

I have figured out the code to resolve IP to hostname, but am stumped on this one.

rollis13
07-18-2013, 02:33 PM
Have a look at Leith Ross's work, could help you to extract what you need: http://www.excelforum.com/excel-programming-vba-macros/771573-ping-host-name-column-a-ip-address-result-column-b-response-time-column-c.html