KentuckyDavid
New Member
- Joined
- Nov 12, 2008
- Messages
- 2
Why on earth can't you "save" an open file as a shortcut to a destination folder of your choice from the Save As dialog???!!!
I often work with multiple Excel files located in multiple folders. I want to be able to create a folder on the desktop, and then save shortcuts to my currently open files in that folder. Remarkably, I cannot find a way to do this! Since the open files (perhaps 15 or more) are located in multiple folders and could be several folders "deep" in some instances, it is an enormous task to (1) write down the names of all the open files; (2) to close all the open files; (3) locate each file again - one at a time - and create and save shortcuts to my desktop folder.
Am I overlooking something simple? Or, is there a macro or downloadable utility to enable this functionality?
THANKS for any help.
David
I often work with multiple Excel files located in multiple folders. I want to be able to create a folder on the desktop, and then save shortcuts to my currently open files in that folder. Remarkably, I cannot find a way to do this! Since the open files (perhaps 15 or more) are located in multiple folders and could be several folders "deep" in some instances, it is an enormous task to (1) write down the names of all the open files; (2) to close all the open files; (3) locate each file again - one at a time - and create and save shortcuts to my desktop folder.
Am I overlooking something simple? Or, is there a macro or downloadable utility to enable this functionality?
THANKS for any help.
David