VBA help - Code to update excel links when file path changes

[jirose93]

Hi all,

I am really struggling to find an answer to my question so hoping someone here might be able to help.

I have a set of Excel documents set up as a template for new jobs each time a new job comes in. When we get a new one in I copy and paste the "template" file and rename it as the new file name.

The file is set up with subfolders, each containing an Excel workbook and they all link to each other (about 50 separate workbooks within the template file) - obviously these links work fine within the original template file but as soon as I copy and paste then none of the links update to the new file path and instead still link back to the original template file.

Can someone tell me if it's possible to have a macro that will automatically update all 50+ Excel workbooks when I copy and paste the template file to reflect the new file path, rather than me having to go into each separate workbook when I copy it over and restore the links manually?

Thank you in advance!!

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules. Be sure to follow & read the link at the end of the rule too!

Cross posted at: VBA help - Code to update excel links when file path changes

If you do cross-post in the future and also provide a link, then there shouldn’t be a problem.