VBA：项目中的多个开发人员 - 并行开发 [英] VBA: Multiple Developers In a Project - Concurrent Development
问题描述
在常规软件开发项目，代码分布在多个文本文件之间。开发人员可以修改和检入单独的文件。在两个开发人员修改同一个文件的情况下，源代码管理系统将提供合并功能来处理任何冲突。
从表面上看，我认为这个概念不能应用于VBA应用程序。它不能应用，因为所有的代码都存储在一个文件中，而且这个文件是专有的二进制格式，所以任何第三方合并工具都无法读取。
是否有可能有多个开发人员一次修改此代码？ Microsoft Office为VBA提供任何种类的合并工具？
有一个VBA的Source Safe插件，您可以阅读这里：
如果您使用其他源代码控制系统（Git，Mercurial等） ：
当我做了很多Excel VBA开发。每当我进行更改（从上下文菜单）时，我都习惯于导出每个文件（模块等）的文本格式。这对我来说很好，并且不需要任何外部工具（有外部工具或基于脚本的解决方案来导出代码，但我更喜欢这种方法）。
My understanding of VBA is that one office document contains a suite of VBA functions, all stored within the same file as the data.
In a conventional software development project, the code is distributed amongst multiple text files. Developers can modify and check in separate files. In the instance where two developers modify the same file, the source control system will provide merge functionality to deal with any conflicts.
On the surface, I would assume that this concept can not apply with a VBA application. It can not apply because all of the code is stored in one file, and this file is in a proprietary binary format, so any third party merge tools cannot read it.
Is it possible to have more than one developer modify this code at once? Does Microsoft Office provide any sort of merge facility for VBA?
There is a Source Safe addin for VBA which you can read about here:
VBA Source Code Control Add-In
If you are using some other source control system (Git, Mercurial etc..) I suggest the following:
When I was doing a lot of Excel VBA development. I got into the habit of exporting to the text format for each file (module, etc) each time I made a change (from the context menu). This worked pretty well for me and didn't require any external tools (there are external tools or script based solutions to exporting your code, but I prefer this approach).
这篇关于VBA：项目中的多个开发人员 - 并行开发的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
