Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Statistics | Excel Discussion (Misc queries) | |||
Statistics - p value | Excel Worksheet Functions | |||
Statistics | Excel Discussion (Misc queries) | |||
Statistics | Excel Discussion (Misc queries) | |||
p-value, statistics | Excel Discussion (Misc queries) |