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("220.127.116.11") in any Excel cell.
GetIpAddress("www.google.com") in any Excel cell.or
Ping("18.104.22.168") in any Excel cell.