tips for organizing code for distribution
 

Any good articles for maintenance of code?

I currently use just the VBA Office comes with for work, and although I'm
not in IT, I'd like to be able to distribute some stuff with code to users.
Some of the reasons I don't include:
1) the security issue - my IT department says it can get me a cert for
$90/year, but I'm thinking I could avoid this if I either used add-ins to
distribute the code, or invested in VB6 and compiled the code (at least I
think those would work)
2) maintenance - I'm wondering what other people do, cause it seems like a
nightmare, particularly if you want to be able to modify code either at work
or at home. Is there a CVS version for VBA? Any utilities out there for
managing projects?
3) off topic but related - I'd love to be able to use unit testing along the
lines of junit. Currently I write a little test with a conditional compile
(i.e., ccDebug = 1), but it's not very elegant or robust. I've tried vbaUnit
and vbLite, but wasn't particularly impressed with either. Maybe another
reason to move up to VB (how much is that anyway?)

Thanks, Eric