T
T
ti_zh_vrach2021-05-05 21:07:58
Visual Basic
ti_zh_vrach, 2021-05-05 21:07:58

Is there a version control system for VBA-Excel?

Good afternoon!
Recently, the task I'm working on has been expanding. I already have 6 versions of the code with radical differences, 4 of which I regularly look at. And it is expected from one to three more versions. There was a need for a version control system. Found one paid plug-in for Excel. And I would like to start with something free, in order to gradually understand what I need from such a thing in my work. For a number of reasons, only the local repository option is possible. This thing must still be considered safe by our security guards. It would be great if it was some kind of plugin that could track changes in both the code and the table. But if only in the code, then it's also great. There are such? What system can be used by a non-real welder?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
B
BasiC2k, 2021-05-06
@ti_zh_vrach

I don't know how complicated your project is, but I would:
1. Determine whether it is one project with variations or several independent projects;
2. Moved the common and static code into a separate module:
3. I would develop the project based on the following considerations: 1 variation - 1 module.
4. Versioning of a file with a macro - raise with each revision.

V
Vladimir Korotenko, 2021-05-05
@firedragon

Hmm, just search?
https://github.com/xlwings/git-xl

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question