VBA Code statistics

  • Thread starter Thread starter R Avery
  • Start date Start date
R

R Avery

Is there any utility that can analyze .bas, .cls, etc files and create a
text file dump or Excel spreadsheet (or whatever) of the statistics of the
modules? Such as comment line count, code line count, code density, number
of procedures, etc?

I have seen one that can do that, but can only analyze 1 module at a time,
and I have directories of like 80+ modules, and I do not want to analyze all
of them individually with this utility. Is there one that can iterate over
all files in a folder?

Any help would be appreciated.
 
Mr. Avery,

There is an excellent utility that does
all that that I use constantly. It's the
VBA Code Documentor version 4.0
developed and distributed (for free)
by Rob Bovey. I have a large number
of code modules in my programs
and it handles them all simultaneously.
I downloaded it so long ago that I
can't remember the specific site
I went to get it, but it's out there
and available. Somebody reading
this message and reply should
have that information.

-- Dennis Eisen
 
DennisE said:
Mr. Avery,

There is an excellent utility that does
all that that I use constantly. It's the
VBA Code Documentor version 4.0
developed and distributed (for free)
by Rob Bovey. I have a large number
of code modules in my programs
and it handles them all simultaneously.
I downloaded it so long ago that I
can't remember the specific site
I went to get it, but it's out there
and available. Somebody reading
this message and reply should
have that information.
Click to expand...

http://www.appspro.com/utilities/Documentor.asp
 
Back
Top