Hello, I need to check the name of a module to change it later.
The name of the module changes a lot, depending on each document, and can not run all possible names, as it would take a long time.
For this I need a code that reads the module names in my VBA project.
What I accomplished so far was this:
Sub Mudar_cód()
ObjVbProj = Workbooks(ActiveWorkbook.Name).VBProject.VBComponents("MFPC0000").CodeModule
If ObjVbProj = "MFPC0000" Then
MsgBox "SIM"
End If
End Sub