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

With file->export file you can export the individual classes.

That's one way to split the modules out - temporarily or otherwise.

Once you've done that, you can then create an SVN repository. I won't go into instructions for that as it's all over the internet, but here's a starting point:

http://svnbook.red-bean.com/en/1.0/ch05s02.html

Answer 2

One of the best SVN clients for windows is tortoise: http://tortoisesvn.tigris.org/ It integrates straight into windows explorer.

For a server, there's visualSVN http://www.visualsvn.com/server/

I've used both quite happily.

Answer 3

Check out this answer on how to automatically extract all modules/forms/classes to text files. Which will make them more manageable in SVN.