NetworkMashup.xls is a spreadsheet with VBA macros I scraped from the Internet to execute pings and name/address resolution from within Excel with WIN32 API calls.
Not only is it handy when you need to do some network mapping in a restricted environment, but also if you’ve just a list of machines to monitor.
The spreadsheet contains several sheets. One sheet to perform a single ping:
One sheet to ping/resolve a list:
One sheet to list the IP addresses of the current machine:
And last, a sheet with settings:
Download here.
Quickpost info
Great functions, but I never use a forms button to execute functions, since they are macro’s you can just call them from any cell:
=ping(A7)
Comment by bonarez — Monday 1 March 2010 @ 16:59
@bonarez You can do that provided you make them public.
Comment by Didier Stevens — Monday 1 March 2010 @ 18:39
[...] Quickpost: NetworkMashup.xls – didierstevens.com NetworkMashup.xls is a spreadsheet with VBA macros to execute pings and name/address resolution from within Excel with WIN32 API calls. [...]
Pingback by Week 9 in Review – 2010 | Infosec Events — Tuesday 9 March 2010 @ 7:06