![]() |
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. |
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 |
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. |
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