ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Code statistics (https://www.excelbanter.com/excel-programming/287116-vba-code-statistics.html)

R Avery

VBA Code statistics
 
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.



DennisE

VBA Code statistics
 
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

Beto[_3_]

VBA Code statistics
 
DennisE wrote:

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.


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

--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.


R Avery

VBA Code statistics
 
Thanks so much. This program is great!



"Beto" wrote in message
...
DennisE wrote:

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.


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

--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.





All times are GMT +1. The time now is 01:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com