JasonExcel
New Member
- Joined
- Mar 9, 2018
- Messages
- 6
I have an Excel file that is looking at a few hundred external Excel files. These external links now need to be changed to new files each of which has a new file path and name. I have a list of all the old files paths and names in column A of a spreadsheet and a list of all the new files paths and names in column B of the same sheet. Is there a way to loop through the spreadsheet and replace all the old external links per column A with their equivalents from the same row in column B.
<tbody>
</tbody>
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
S:\OldPath\OldName3.xlsx | S:\NewPath\NewName3.xlsx |
<tbody>
</tbody>