Because my folder is so large, the file save/close is taking a very long time.
I have found that if I save the wb to an empty folder the save time is much less time consuming. But I always want to have the file saved in the larger folder where it is the "home" folder.
Therefore, is it possible to save the wb to an empty folder, close the file,
and have the file copied to the "home" folder before the user wants to reopen this file again (from the "home" folder).
I have found that if I save the wb to an empty folder the save time is much less time consuming. But I always want to have the file saved in the larger folder where it is the "home" folder.
Therefore, is it possible to save the wb to an empty folder, close the file,
and have the file copied to the "home" folder before the user wants to reopen this file again (from the "home" folder).