I’m always looking for this, so I figure here is as good as any for safe keeping.. It’s simple to use…
- 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.