Free Open-Source-Tool for counting the lines of code in Excel Add-ins (.xlam)
|Excel versions||2010-2019 (Windows)|
|Where is the add-in after activation?||"Developer" tab, new group "Add-in Code Counter"|
|File size||27 KB|
|Lines of code (total)||258|
|Source lines of code||190|
|Comment lines of code||27|
The source code is published on GitHub and can also be opened in the VBA editor.
The tool is shipped as an add-in for Microsoft Excel (.xlam). After installation and activation a new group “Add-in Code Counter” is added to the “Developer” tab.
Download version 1.1 – it´s free!
Automatic installation (recommended for Windows)
Number of downloads of previous versions: 33
– Counting lines of code (active source code, comment lines, blank lines, total lines) of a whole VBA project
– Optional: Counting lines of code of each component of the VBA Project individually, such as modules, class modules, user forms and worksheets
– Optional: Writing the results to a plain text file
This add-in is being developed and maintained with private effort and provided for free download. I would be very happy about a small donation to this foundation for sick children in the region of Heilbronn/Germany. Read more on the website of the foundation.