How to replace links to other workbooks with codes in Vba

Hi guys,

is it possible to replace links with other workbooks with codes in Vba without writing the code line by line for evrey cell that use a link?

Thanks for your help

You can try with this macro:

Please Login or Register  to view this content.

Regards,
Antonio

i didn't mean the link in VBA but the links between Workbooks in "Edition>Links" (i thinks it's links, my Excel is in french so i have "liaisons" it's the second function for the bottom)

Is it possible to replace this functions by codes

Thanks for your help

My previous macro should do what you need. If you fill correctly oldWorkbook and newWorkbook the macro replace old workbook name with new.
Regards,
Antonio