Change auto destination in Save As ???

[Bubey]

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.

 

[Nick Hodge]

Bubey

Change the path in Tools>Options...>General>Default file location

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Bubey]

Thanks Nick. It worked and so simple.

"Nick Hodge"
message
Bubey

Change the path in
Tools>Options...>General>Default file location

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk


message
news:[email protected]...

 

[Bubey]

One more question please......How can I change the
opening destination?
When I clicked on File/Open, it opened into the My
Doc's on the C drive
rather than the My Doc's on the E drive.

"Nick Hodge"
message
Bubey

Change the path in
Tools>Options...>General>Default file location

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk


message
news:[email protected]...

 

[Nick Hodge]

Strangely, you can't (Well there may be a setting in the registry, but not
wise)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[MartinW]

It does here. Both the Save As and File Open dialogs open to
the folder I have specified in File locations.

The one that bugs me and I can't change is the Insert Picture from file.
It always goes to the My Pictures folder in My Documents.

I use Excell 2000.

Regards
Martin

 

[Nick Hodge]

Martin

Staggeringly it does here too. Shows how much I open files through
File>Open... maybe?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[MartinW]

Yeah I tend to do most things from Windows Explorer with the
odd File Open here and there.

People are always telling me that it is more efficient to use shortcut
windows and drag and drop etc. Funnily enough the same people
always come to me when they are looking for lost files or when
folders and files get all muddled. The most common statement
is "I'm sure I saved it, but when I went back this morning it wasn't there.

Cheers
Martin

 

[Bubey]

Where do I find the "File Locations" to make this
change?

It does here. Both the Save As and File Open
dialogs open to
the folder I have specified in File locations.

The one that bugs me and I can't change is the
Insert Picture from file.
It always goes to the My Pictures folder in My
Documents.

I use Excell 2000.

Regards
Martin

 

[Nick Hodge]

Bubey

We have decided the default file location under Tools>Options...>General,
works for both open and save. It will not obviously work for New... which
defaults to the template location

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk