Hey all,
i have a folder containing subfolder and each one has some excel sheets which all are connected to a single excel file.
I have to move this folder to other computer, and I need a code or something to open each file and then:
1) change source to the linked file to the new location.
2) update values from the external link and then save and close.
i have a folder containing subfolder and each one has some excel sheets which all are connected to a single excel file.
I have to move this folder to other computer, and I need a code or something to open each file and then:
1) change source to the linked file to the new location.
2) update values from the external link and then save and close.