We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Macro LoC


Is there any approach to determine the number of lines of code within a macro. I’m looking something equivalent to the VB code below

With ActiveWorkbook.VBProject
For i = .VBComponents.count To 1 Step -1
Dim loc As Integer
loc = .VBComponents(i).CodeModule.CountOfLines
If loc > 0 Then
MsgBox (loc)
End If
Next i
End With



I am afraid, we don’t support to access or manipulate macros, so your desired feature is not available at the moment. I have logged your feature request into our issue tracking system with an id: CELLSNET-20488. We might look into it in future.

Thank you.