Thanks Nick. It worked and so simple.

"Nick Hodge"
wrote in
message
...
Bubey

Change the path in
ToolsOptions...GeneralDefault file location

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Bubey" wrote in
message
...
I would like to be able to change the destination
when I do a Save As.
I have an external hard drive that I keep all my
documents on so when
I do a save as it automatically goes to the
Windows My Documents folder.
I would like it to go to the external hard drive
My Documents folder.
Thanks in advance for the help.