在Eclipse IDE上使用VBA [英] Working with VBA on Eclipse IDE
问题描述
可能重复：
任何廉价或免费的IDE在VB6编程中？
我们计划编写复杂的VB6项目。现在，当合法的MS Visual Studio 6很少时，在我们的组织中，我们需要寻找替代环境。 VBA的范例，即嵌入到单个xlsx / docx文件中的所有代码对于我们的目的来说都是不够的。我们还需要一些bug跟踪。
We plan to write complex VB6 projects. Now, when the legit MS Visual Studio 6 is scarce, in our organization we need to look for alternative environments. The paradigm of VBA, i.e. having all code embedded into a single xlsx/docx file is insuficient for our purposes. We also need some sort of bug tracking.
我知道Eclipse和VBA只是两个独立的世界...但是还有一些集成存在吗？我特别寻找：
I know that Eclipse and VBA are just two separate worlds... but still, does some sort of integration exist? I'm looking in particular for:
- 开发完成了可管理的.bas和.cls文本文件，而不是一个大的二进制容器。 li>
- 某种调试功能。我不希望有什么可以匹配的VB6，但至少有一些形式的自动导入&将代码导出到某些支持VBA的容器中（如.xlsx，docx）
- VBA语法高亮显示
- 某种Intelli-Sense完成）
- 与EGit和Mylyn集成
- Development done in manageable .bas and .cls text files, not one big binary container.
- Some sort of debugging capabilities. I don't expect something to match VB6, but at least some form of automatic import & export of the code into some VBA-capable container (like .xlsx, docx)
- VBA Syntax highlighting
- Some sort of Intelli-Sense (code completion)
- Integration with EGit and Mylyn
我知道，我可以粘贴一些东西使用自定义宏，Notepad ++，TortoiseGit等工具，但Eclipse已经有很多功能我们在我们的组织中使用它，所以人们不需要学习很多新东西。
I know, that I can glue something up with tools like custom macro, Notepad++, TortoiseGit etc. But the Eclipse already has a lot of functionality in place, and we use it in our organization anyway, so people wouldn't need to learn a lot of new stuff.
推荐答案
简短的答案是不，它不。原因是VB6编译器是VB6的一部分，另一个IDE需要一个VB6许可证才能使用它（如果你有VB6 IDE）或另一个编译器。另外，如果Eclipse支持VB6，那么我会期待一个快速的网页搜索来显示。
Short answer is No, it doesn't. The reason is that the VB6 compiler is part of VB6 another IDE would need a VB6 licence to use it (and if you have that then you have the VB6 IDE) or another compiler. Also if Eclipse supported VB6 then I'd expect a quick web search to reveal that.
如果您的主要关注点是具有VB代码功能的IDE的可用性，然后移植您的VB到VB.Net将是您长期的最佳选择。
If your main concern is availability of an IDE with VB code features then porting your VB to VB.Net is going to be your best option in the long term.
这篇关于在Eclipse IDE上使用VBA的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
