Hello all!

I started learning Excel VBA scripting informally a few years ago, and
have been putting together increasingly complex utility scripts on an
as needed basis. I've now gotten to the point where I've rewritten
this stuff enough that I'd like to collect and modularize some of this
code in a more reusable way. I'm more of a LAMP / *nix developer, so
I'm hoping to be able to come up with a fairly lightweight solution
that doesn't require a heavyweight switch in my development tools
(e.g. switching to Visual Studio). I also have been informal (=lazy)
about tracking the macros I've written, so I have two questions for
you:

#1. Is it possible to somehow scan for or otherwise locate spreadsheet
files that have macros or scripts in them, so that I can collect all
the VBA functions I've written?

#2. If I want to collect all of these VBA functions and snippets into
a centralized location (vs cloning them in each spreadsheet I want to
use), what is the easiest way to do that? I know it is possible to put
this code in separate "Module" files, but I don't really understand
where those are stored or how you would deploy them (I'd like
something I can have on multiple machines, ideally via SyncToy or
something similar).

Thanks!

Ramon