Forum Discussion
Kendethar
Sep 02, 2021Iron Contributor
Count all VBA code lines in Workbook (Code)
Greetings all, Initially Inspired by the_net_2.0 on https://www.access-programmers.co.uk/forums/threads/count-lines-of-code-in-a-vba-project.215677/, I wrote code to count how many lines of cod...
- Aug 14, 2022
Of course! I should have to begin with. Thank you for your request. Below is the revised/better version.
Option Explicit Sub CodeCounter() On Error GoTo CodeLineCount_Err Dim CodeLineCount_Var As Object, CodeLineCount As Double, CodeLineCount_Total As Integer Set CodeLineCount_Var = ThisWorkbook.VBProject For Each CodeLineCount_Var In CodeLineCount_Var.VBComponents CodeLineCount = CodeLineCount + CodeLineCount_Var.CodeModule.CountOfLines Next CodeLineCount_Total = CodeLineCount CodeLineCount_Err: Set CodeLineCount_Var = Nothing MsgBox CodeLineCount_Total End Sub
Please let me know if you or anyone reading this has even better improvements.
Juliano-Petrukio
Sep 02, 2021Bronze Contributor
Congratulations.
Just a highlight that will be necessary the user enable the option "Trust access to the VBA project object model"
File" > "Options" > "Trust Center" > "Trust Center Settings"
And the library Microsoft Visual Basic For Applications Extensibility XX
Just a highlight that will be necessary the user enable the option "Trust access to the VBA project object model"
File" > "Options" > "Trust Center" > "Trust Center Settings"
And the library Microsoft Visual Basic For Applications Extensibility XX