I need to be able to search for text in macros. I can do this in modules, but I can't figure out how to interact with macros. For example this code:
This works I specify CodeModules but errors for CountOfLines when I include macros. .Name does work for macros but I can't find anyplace that explains what I can do with macros.
For Each objComponent In Application.VBE.ActiveVBProject.VBComponents Debug.Print objComponent.Name Debug.Print objComponent.CountOfLines Next objComponent