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!
- Press Alt-F11 in Excel to get to the VBA screen.
- Right click on the Project View
- Click Add Module
- Add the following snippet.
GetHostname("126.96.36.199") in any Excel cell.
GetIpAddress("www.google.com") in any Excel cell.or
Ping("188.8.131.52") in any Excel cell.