Jun 8, 2010VBA Sync Tool synchronizes macros between a VBA-enabled file and a folder, enabling easy version control using Git, SVN, Mercurial, or any other Best way to do Version Control for MS Excel [closed] - Stack OverflowVersion control system for Excel-VBA code [closed] - Stack OverflowSource control of Excel VBA code modules - Stack Overflowgit - How to perform better document version control on Excel files More results from stackoverflow.com
Jun 8, 2010VBA Sync Tool synchronizes macros between a VBA-enabled file and a folder, enabling easy version control using Git, SVN, Mercurial, or any other Version control system for Excel-VBA code [closed]Best way to do Version Control for MS Excel [closed]Source control of Excel VBA code modulesVersion Control for Access VBA code? [duplicate]More results from stackoverflow.com
Jun 8, 2010VBA Sync Tool synchronizes macros between a VBA-enabled file and a folder, enabling easy version control using Git, SVN, Mercurial, or any other Version control system for Excel-VBA code [closed]Best way to do Version Control for MS Excel [closed]How to put Excel VBA into gitSource control of Excel VBA code modulesMore results from stackoverflow.com
I've just setup a spreadsheet that uses Bazaar, with manual checkin/out via TortiseBZR. Given that the topic helped me with the save portion, I wan...Best answer · 67
TortoiseSVN is an astonishingly good Windows client for the Subversion version control system. One feature which I just discovered that it has is...45
Let me summarise what you would like to version control and why: What: Code (VBA) Spreadsheets (Formulae) Spreadsheets (Values) Charts ... Why: Au...12
It depends whether you are talking about data, or the code contained within a spreadsheet. While I have a strong dislike of Microsoft's Visual Sour...9
I'm not aware of a tool that does this well but I've seen a variety of homegrown solutions. The common thread of these is to minimise the binary da...7
I use git , and today I ported this (git-xlsx-textconv) to Python, since my project is based on Python code, and it interacts with Excel files....6
Working upon @Demosthenex work, @Tmdean and @Jon Crowell invaluable comments! (+1 them) I save module files in git\ dir beside workbook location. C...6
Taking @Demosthenex 's answer a step further, if you'd like to also keep track of the code in your Microsoft Excel Objects and UserForms you have t...6
One thing you could do is to have the following snippet in your Workbook: Sub SaveCodeModules()
'This code Exports all VBA modules
Dim i%, sName$...3
Check out this excel addin https://github.com/hilkoc/vbaDeveloper .
It exports all your vba code automatically, as soon as you save your workbook....7
I wrote a small tool to help with putting VBA code under version control, without requiring anything from Excel, or locking you into any specific v...6
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 don...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.2