How to use version control with VBA code?

svn, vba, version-control

Solution

Check out this excel addin https://github.com/hilkoc/vbaDeveloper .

It exports all your vba code automatically, as soon as you save your workbook. You can also easily import it again, when you open a workbook. It all work very nicely.

As a bonus, it comes with a code formatter that you can run within the vba editor, so you can format your code as you write.

Problem

I am developing a VBA application which is quite large. I want to use SVN for that application developing. How can I split my modules from the Excel document and how to upload my modules separately to source control? Please help me.

Original source

Related problems