Steve asked on my previous posting in regards to DNS Lookup in Excel if forward lookup could be done. (Find the IP Address from the Hostname). Believe it or not I one up your request. How about DNS Forward and Reverse lookup as well as Ping!

1. Press Alt-F11 in Excel to get to the VBA screen.
2. Right click on the Project View
3. Click Add Module
4. Add the following snippet.
5. Use: GetHostname("4.2.2.1") in any Excel cell.
or
Use: GetIpAddress("www.google.com") in any Excel cell.
or
   Use: Ping("4.2.2.1") in any Excel cell.


Continue reading →