VBA diagramming tool?

[CP]

Hi. A colleague of mine developed a great application using VBA in Access
97. Now, our company is transitioning to Windows XP and we need to convert
that application to the Access that runs with XP (sorry, I don't know if
it's called Access 2000 or Access 2002 or what). During the heat of
development, my colleague didn't really keep good track of the flow of his
program (who does?).

Now, instead of me having to review all the modules and chart each one with
its' connections, I'm wondering if there is a tool that can analyze his VBA
code and do that for me? I've looked a bit a Total Access Analyzer which
looks like it would do the trick but it's too expensive for us especially
since we only need to do this
one analysis. Does anyone know of a similar program or at least a program
that might perform the same function?

Thanks in advance. Carol.

 

[CP]

Thanks, Joan, but I just found out that our company is also transitioning to
Access for XP and that's why we need to convert. So, if anyone knows of a
utility to document the VBA portion of our program, I'd appreciate hearing
about it.

Thanks.

Carol.

 

[Douglas J. Steele]

In addition to what the others have told you, you might find Total Access
Analyzer, from FMS, to be useful.

http://www.fmsinc.com/products/analyzer/index.html

 

[CP]

Thanks, Chris. I can print each module but it's time consuming to go
through each and figure out what functions/etc. are called and what each of
those do.

Any other ideas? Thanks. Carol.

 

[CP]

Thanks, Doug. Yes, I'd like to try that program but it's just too
expensive for our 1-time use.

 

[Douglas J. Steele]

What's your time worth? If it saves you a day, is that worth $300? (And it's
guaranteed to save you many days)

See http://www.fmsinc.com/products/analyzer/2000/convince.html for more
arguments.

 

[CP]

Good point but you'd be surprised how so many managers don't think that way
(or you might not be surprised). If it doesn't go into a line item other
than salaries, then it doesn't matter.

Thanks. Carol.