Hello,
My current project requires a lot of changes in one Excel Workbook, especially in VBA, which is about 2000 lines of code so far
So, we need some collaboration on it. Is there any possibility to work with it as with regular code:
1) use git for managing versions and see diffs
2) merge changes from several participants
3) use some IDE to make easier debug?
I don't often collaborate on VBA (don't really write anything more than code for specific task in VBA).
But you can do following.
1. You'd export .bas, .cls, or .frm and use exported files to use Git hook.
2. You'd want something like Git XL (free, open-source Git command line extension)
https://www.xltrail.com/blog/git-merge-excel-vba
3. Not sure on this one. You can always use VS Code, I suppose. There is extension called "VSCode VBA" that adds syntax highlighting.
Or use Rubberduck add-in.
http://rubberduckvba.com/
EDIT: For #2, consider combining Git XL with SourceTree. https://www.sourcetreeapp.com/
Last edited by CK76; 02-24-2020 at 12:21 PM.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thanks, need some time to try and investigate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks