Change vba code with vba code

[Maurizio]

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

 

[Zack Barresse]

double post...

http://www.mrexcel.com/board2/viewtopic.php?t=78297