Can Subversion be used with Excel and VBA?

Hi Experts,

Day 2 with a new client and I’ve run head first into version issues! A workbook that I’m supposed to code with fails to load because it needs a specific version of an add-in.

I’ll eventually get this fixed, but I really need to get version control in place immediately.

The client uses SUBVERSION; however, I’ve never used this before. A quick search through online documentation and I didn’t find any Excel / VBA references.

Can Excel files be held in a Subversion repository?
Can VBA code modules be held in a Subversion repository?
Any further advise as to how to get this up and running for Excel VBA through the development team?
Who is Participating?
Kalpesh ChhatralaConnect With a Mentor Software ConsultantCommented:
you can also try tortoisesvn
I have not experienced this as yet.  But I think, Excel files can be versioned in svn.  They will be versioned like any other binary file.  And since VBA code is stored in the excel file itself, this should also be versioned.  I have used svn earlier but not using it in my current job, so may not affirm if this is 100% right.  Please test by creating a repository in the svn server.
Kalpesh ChhatralaSoftware ConsultantCommented:
you can use Sub Version System for  Office Suite 2007
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Kalpesh ChhatralaSoftware ConsultantCommented:
you can use Source Safe for Documents and VBA Code
wobbledConnect With a Mentor Commented:
svn can store any binary based file so yes you can use it on Excel files (of which the VBA part is held within it)
JohnDiddy77Author Commented:
Thanks for the quick response! So, Subversion will handle Excel files as a Binary.

@kalpesh2804: I'm developing with Office 2003, and the SVN Office Client is for 2007. Are there any good SVN Clients for Office 2003?
JohnDiddy77Author Commented:
kalpesh2804: Thanks once again! So, with TortoiseSVN, do I run Version Checking from Windows Explorer or does it integrate with Office 2003?
Kalpesh ChhatralaSoftware ConsultantCommented:
Check this link to integrate with Office Suite
You can try Alfresco
File management (version history etc), open source with Microsoft Office Integration

JohnDiddy77Author Commented:
We've settled with TortoiseSVN using Windows Explorer. When we need to compare code modules we'll export the code as a text file and use SVN to compare.

Thank you all for your assistance!

John Diddy
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.