Excel-VBA代码的版本控制系统 [英] Version control system for Excel-VBA code

问题描述

我正在寻找一种版本控制系统，可以将其用于VBA代码，可能采用加载项的形式，但类似于 SVN 或 Git ，甚至是商业软件.我知道在此处和有，但是它们已经超过6年了，并不完全是我想拥有什么.而且我知道一个人可以只对代码使用 Tortoise SVN ，而不能对整个项目(代码+表的所有模块)使用 Tortoise SVN ，而且我知道，它可以手动完成.

I am looking for a version control system which I can use for the Code of VBA possibly in a form of add-in but similar to SVN or Git or even a commercial software. I know there is a discussion here and there however, they are older than 6 years and that is not exactly what I want to have. And I know one can use Tortoise SVN just for the code but not for the whole project (all modules of the code+tables) and I am aware of it that one can do it manually.

推荐答案

注意:此功能已被删除. Rubberduck仍允许将所有代码文件从VBA项目导出到文件系统，但是从2019/02/08开始，尽管它允许导入所有代码文件.一次，它不会在导入时覆盖现有模块，这使该答案几乎无效.

NOTE: This feature has since been removed. Rubberduck still allows exporting all code files from a VBA project to the file system, but as of 2019/02/08 while it allows importing all code files at once, it will not overwrite existing modules on import, which makes this answer pretty much invalid.

免责声明:我是Rubberduck VBA项目的撰稿人.

Disclaimer: I'm a contributor on the Rubberduck VBA project.

VBE的Rubberduck VBA外接程序添加了许多功能，包括所有VBA主机的源代码控制.它是积极开发，开放源代码和免费的，并且可以从Excel 2000开始在所有版本的Excel(以及Access，Word，PowerPoint等)中使用，并在32位和64位版本的Office中运行

The Rubberduck VBA add-in for the VBE, adds a number of features, including Source Control for all VBA hosts. It's actively developed, open source and free, and works in all versions of Excel (and Access, and Word, and PowerPoint, etc) from Excel 2000 onwards, and in 32 and 64-bit versions of Office

Rubberduck使用LibGit2Sharp库，因此您可以直接与GitHub和其他基于云的服务集成，也可以将模块和表单直接导出到文件夹中.

Rubberduck uses the LibGit2Sharp library, so you can integrate directly with GitHub and other cloud based services, or you can simply export modules and forms to a folder.

您可以在GitHub上找到该项目: https://github.com/rubberduck-vba/橡皮鸭

You can find the project on GitHub here: https://github.com/rubberduck-vba/Rubberduck

这篇关于Excel-VBA代码的版本控制系统的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！