如何在 VBA 代码中使用版本控制? [英] How to use version control with VBA code?

问题描述

我正在开发一个非常大的 VBA 应用程序.我想使用 SVN 来开发该应用程序.

I am developing a VBA application which is quite large. I want to use SVN for that application developing.

如何从 Excel 文档中拆分我的模块以及如何将我的模块分别上传到源代码管理?

How can I split my modules from the Excel document and how to upload my modules separately to source control?

请帮帮我.

推荐答案

查看这个 excel 插件 https://github.com/hilkoc/vbaDeveloper .

Check out this excel addin https://github.com/hilkoc/vbaDeveloper .

一旦您保存工作簿，它就会自动导出您的所有 vba 代码.您还可以在打开工作簿时轻松地再次导入它.一切都很好.

It exports all your vba code automatically, as soon as you save your workbook. You can also easily import it again, when you open a workbook. It all work very nicely.

作为奖励，它带有一个代码格式化程序，您可以在 vba 编辑器中运行该程序，因此您可以在编写代码时格式化代码.

As a bonus, it comes with a code formatter that you can run within the vba editor, so you can format your code as you write.

这篇关于如何在 VBA 代码中使用版本控制?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！