Hi all,
I have a summary workbook that links to a few other workbooks, now in order to update the links quickly, I want to open and close these other workbooks, but they are rather big in size and often happen to be in "use" as they are all on a shared drive. How can I write a Macro that opens and closes them in "safe mode" or any mode that speeds up the whole opening and closing process? I just need to refresh the data in my summary file. Updating the links while the other files are closed, gets Excel to crash every time.
Below code is what I'm using currently. Unfortunately, it is incredibly slow and if someone is currently using below file, VBA does not even seem to let me open it.
Please Login or Register to view this content.
Bookmarks