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.
Didier Stevens 
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
Didier,
Any chance you can update this so that it can run on 64 bit machines?
Thanks
Robert
Comment by roayers — Thursday 14 July 2011 @ 18:31
@roayers Probably, but not in the coming weeks.
Comment by Didier Stevens — Thursday 14 July 2011 @ 20:32