vba 将所有 excel 加载项模块导出到 .bas 文件的最快方法是什么？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/11362404/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What's the fastest way to export all excel add-in modules to .bas files?
提问by Davuz
I'm working on an big excel-addin with many modules. I need to export them to .bas file to manage them with SVN. I know a hot key to export them fast, Ctrl+E. But the number of my modules is too many that I still lose too much time to export them. Does anyone know a faster way to do this?
我正在开发一个包含许多模块的大型 excel 插件。我需要将它们导出到 .bas 文件以使用 SVN 管理它们。我知道一个快速导出它们的热键，Ctrl+E。但是我的模块数量太多，我仍然浪费太多时间来导出它们。有谁知道更快的方法来做到这一点？
采纳答案by Tim Williams
This is a great tool which should do what you need
这是一个很棒的工具，应该可以满足您的需求
http://www.appspro.com/Utilities/CodeCleaner.htm
http://www.appspro.com/Utilities/CodeCleaner.htm
From their website:
从他们的网站：
Export Code Files - This feature allows you to export all the code files from a project to the directory you specify without the need to perform a project cleaning.
导出代码文件 - 此功能允许您将项目中的所有代码文件导出到您指定的目录，而无需执行项目清理。
If you are having trouble locating the menu option, see the above page for information:
如果您在定位菜单选项时遇到问题，请参阅以上页面以获取信息：
You must set your security to trust access to Visual Basic projects in order to use the code cleaner.
In Excel 2007 the code cleaner can only be run from the VBE Tools menu. There will be no option to run the code cleaner from the new Excel 2007 Ribbon user interface.
您必须将安全设置为信任对 Visual Basic 项目的访问才能使用代码清理器。
在 Excel 2007 中，代码清理器只能从 VBE 工具菜单运行。没有选项可以从新的 Excel 2007 功能区用户界面运行代码清理器。
