Utility Program that reads your VBA

[mark hansen]

I program in Excel VBA mostly and I was wondering if there was a utility program that would read the VB we have written and break it down for us. Similar to a program I used a LONG TIME ago.

Way (way, way) back I cut my teeth on programming dBase III, III+ and IV. When we complete the project we ran a utility program that read the code and printed it out in a neat format. It even adjusting our indention (on the documented printout only), numbered each line and drew brackets to indicate the If Then Else statements and ended the brackets at the End If line. It did the same thing for the other kinds of loops too(Do While etc.). Additionally, at the top of each sub routine it listed the public and private variables, told us what lines the variable was used in the sub routine and what other sub routines were called. All we had to do was to tell it what was the top level routine.

It really documented what we did very well.

I don't suppose anyone knows if there is something like that for VBA code we write in Excel?

Thanks,
Mark

 

[shg]

What I use: Office Automation Ltd. - Smart Indenter

 

[mole999]

Indentation try Office Automation Ltd. - Smart Indenter its very old but still works (well atleast in 32 bit, not sure about 64 bit)

 

[mark hansen]

Thanks!!! I look into that!!

 

[shg]

You're welcome.