Forum Discussion
Changing automatically several links on several files in Excel
Hello Everyone, I am trying to update a bulk of Excel files and each has about 30 links to file from the previous quarter, say "122021". How do I update this automatically, each quarter (first on o...
Thank you for your response. I however tried this and it did not work for me. Maybe I didnt explain properly my problem, apologies.
In each file, I have several links pointing to diffferent files with a part of the name being 122021. These file have the same structure as the file with name 032022. As I am trying to roll forward the 032022 file to 062022, I need to change all the links with name 122021 to 032022.
This roll forward to be done for about 15 files of similar structure (with differing links)
Please if you have any proposals, it will be much appreciated.
Are the filenames part of cell formulas?
Yes they are.
In that case, I don't understand why the code doesn't work...