title: Working with VBA on Eclipse IDE
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1766514/any-cheap-or-free-ides-out-there-for-vb6-programming">Any cheap or free IDE’s out there for VB6 programming?</a>  </p>
  </blockquote>
  
  
  
  <p>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. </p>
  
  <p>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:</p>
  
  <ul>
  <li>Development done in manageable .bas and .cls text files, not one big binary container.</li>
  <li>Some sort of debugging capabilities. I don't expect something to match VB6, but at least some form of automatic import &amp; export of the code into some VBA-capable container (like .xlsx, docx)</li>
  <li>VBA Syntax highlighting </li>
  <li>Some sort of Intelli-Sense (code completion)</li>
  <li>Integration with EGit and Mylyn</li>
  </ul>
  
  <p>I know, that I can glue something up with tools like <a href="http://www.rondebruin.nl/vbaimportexport.htm" rel="nofollow noreferrer">custom macro</a>, 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.</p>