setting a dedicated place to open an "xls" file

[Raymond]

Gentlemen, I do work at the office evey day on spread sheets and save to a
disk, which I bring home.
Is there any way that I can "lock in" a dedicated point to retrieve my files
once I have saved them to "c:\documents & Settings\my documents. When I
click "Open and go to "A" drive to get the file from the disk that I took
home, my computer "remembers" that this was the last place I opened a file
from. And when I am in Excel and want to open a file, the computer looks in
"a".
Thanks Raymond

 

[Chewy]

Tools / Options / General Tab - Default File location

 

[Gord Dibben]

Raymond

Not a good idea to save to or open from removable media. You will eventually
corrupt these files.

Not "maybe" but "for sure".

Save to HDD then copy to the disk.

At home, insert disk and.........

Use Windows Explorer to first copy the files to your HDD into the default
folder designated in Tools>Options>General "Default file location".

Open in Excel from that folder.

Gord Dibben Excel MVP