Book a Demo

Author Topic: EA and VBA (particularly Access)  (Read 7260 times)

Matt

  • EA User
  • **
  • Posts: 96
  • Karma: +0/-0
    • View Profile
    • Solutions Reality
EA and VBA (particularly Access)
« on: April 15, 2002, 09:45:34 am »
Ok folks, here goes.....

I am currently doing a lot of Access VBA development and would like to use UML to  model all of the classes, modules forms etc as I go along - good software engineering etc.....

Now EA will happily help me to manage the VB aspects of the project - classes and ActiveX controls etc.  Unfortunately, there is no way to hook it into the VBA needed in the project.

However, what I was thinking was that if I was to automatically create a VB project that mapped to the VBA creating forms etc programmatically from the info in VBA then I would be able to import it all into EA and document what is needed.

If I was then to write a reverse tool to generate Access from the VB definitions then it would seem as though this could work.

A number of questions then -
1) Does this seem a sensible approach?
2) Is there any tools out there that will do this for me?
3) Would anyone else be interested if I did this?
4) Geoff, is there any intention to make EA pickup VBA anyway?
5) Would I be better to generate XMI for the import, but it would not solve the Access creation issues

Any thoughts, comments or even derision, welcome.....

Matt ;D