Didier Stevens

Monday 1 March 2010

Quickpost: NetworkMashup.xls

Filed under: My Software,Quickpost — Didier Stevens @ 6:11

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


5 Comments »

  1. 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

  2. @bonarez You can do that provided you make them public.

    Comment by Didier Stevens — Monday 1 March 2010 @ 18:39

  3. [...] 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

  4. 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

  5. @roayers Probably, but not in the coming weeks.

    Comment by Didier Stevens — Thursday 14 July 2011 @ 20:32


RSS feed for comments on this post. TrackBack URI

Leave a Reply (comments are moderated)

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 231 other followers

%d bloggers like this: