views:

1180

answers:

3

Can anyone recommend an SVN client for use in Excel with VBA (code modules only). Ideally, I would also like SVN to ignore case when diffing prior to committing changes so as to avoid excessive churn in the repository (VBA has an annoying habit of changing the case of variables all over the project).

+1  A: 

TortoiseSVN integrates well with the Windows File Explorer and allows for the integration of an external diff tool (like Beyond Compare.

Beyond Compare has a specific plugin for Visual Basic code that appears to ignore case for 'unimportant text', meaning anything not in quotes.

I don't think this will solve the SVN churn issue, however. I don't believe that SVN uses the external diff program to decide whether a file has changed prior to committing, and I don't know of any way to override this behavior.

Ken Gentle
One workaround I found was to setup a workspace in Beyond Compare that compared the .svn\text-base folder to the working copy folder. That allowed me do a quick diff with rules so that I could revert case-only changes before examining the other diffs prior to commit.
Barry-Jon
TortoiseSVN is for the file explorer, the question was about VBA in Excel
chiccodoro
+1  A: 

http://www.codeproject.com/KB/office/SourceTools.aspx might do what you want

neuwirthe
I wonder why this wasn't upvoted although it's the only accurate answer.
chiccodoro
+1  A: 

Have a look at the following applications.

http://officesvn.codeplex.com/

http://code.google.com/p/msofficesvn/

Niketya
That's quite cool !
Barry-Jon
Neither of those have special support for VBA, do they?
chiccodoro