svn - How to use version control with VBA code?

Question

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.

Answer 1

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.