Hello,
I have two workbooks that are linked and do calculations giving a result with numbers based on sheets within both workbooks. However, when i copy these workbooks the filepath remains to the original file. The folder name will change each time. I need some code to eliminate the filepath and just keep the specified link.
It appears like this in the formula bar:
='C:\Users\vanderp\Desktop\Master Folder\1. Operations & Tasks\[Tasks 001-025.xlsb]001'!$AR$16
but it needs to be this:
='[Tasks 001-025.xlsb]001'!$AR$16
There are hundreds of links to different cells. If I could get some sort of code to eliminate everything between ' and [ in the formula bar that would be perfect as the links would then only recognize the workbook that is open.
Bookmarks