Hi All,
I was wondering if someone could assist me with a code that opens files from a specified location and then closes them again without saving any changes (to allow refreshing of links).
We run a consolidation model that requires the opening of a lot of files for the final file to update, and it would be great if we had a code to automatically open all files and then go back and close them again.
I have attached a spreadsheet with all the file paths, folders and file names that need to be opened and closed.
Any assistance would be greatly appreciated.
Thank you
Herbz
Reply With Quote