Hi all,
into "Each vbp In ThisWorkbook.VBProject.VBComponents" how can I, with VBA code, change this code's string:
from:
Public Const CTBOld = "Contab03OLD.xls"
Public Const CTB = "Contab03.xls"
to:
Public Const CTBOld = "Contab04OLD.xls"
Public Const CTB = "Contab04.xls"
For example:
For Each vbp In ThisWorkbook.VBProject.VBComponents
With vbp
With vbp.CodeModule
????????????????????????
?????????????????????????
?????????????????????????
End With
End With
Next vbp
End Sub
into "Each vbp In ThisWorkbook.VBProject.VBComponents" how can I, with VBA code, change this code's string:
from:
Public Const CTBOld = "Contab03OLD.xls"
Public Const CTB = "Contab03.xls"
to:
Public Const CTBOld = "Contab04OLD.xls"
Public Const CTB = "Contab04.xls"
For example:
For Each vbp In ThisWorkbook.VBProject.VBComponents
With vbp
With vbp.CodeModule
????????????????????????
?????????????????????????
?????????????????????????
End With
End With
Next vbp
End Sub