When I was doing a lot of VBA work like this, I used an OSS tool that would export all of the code and check it into SVN. I can't remember the name of it for the life of me, though, but it's probably hiding on a drive somewhere.

edit: This was probably it https://www.codeproject.com/Articles/18029/SourceTools-xla