I change the default file location setting a lot in Excel, to hop from project to project many times a day. To do this I have to re-type the full file path of the current project, which is routinely four or five sub-folders long. With some of my co-workers setting up folder names that are very wordy, the scope for making typos is considerable - and every time I get it wrong, I have to start all over again.
I'd much prefer to use a procedure similar to the one that MS Word uses, i.e. a point-and-click dialog to set the required subfolder. Is it possible to switch to such a procedure in Excel, or alternatively, has anyone written a routine that will do this?
Cheers,
DQR
I'd much prefer to use a procedure similar to the one that MS Word uses, i.e. a point-and-click dialog to set the required subfolder. Is it possible to switch to such a procedure in Excel, or alternatively, has anyone written a routine that will do this?
Cheers,
DQR