Possible Duplicate:
Any cheap or free IDE’s out there for VB6 programming?
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.
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:
- 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
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.