Change auto destination in Save As ???
 

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.

Change auto destination in Save As ???
 

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.

Change auto destination in Save As ???
 

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.

Change auto destination in Save As ???
 

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"
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.

Change auto destination in Save As ???
 

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

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


"Bubey" wrote in message
...
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"
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.

Change auto destination in Save As ???
 

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

Change auto destination in Save As ???
 

Martin

Staggeringly it does here too. Shows how much I open files through
FileOpen... maybe?

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


"MartinW" wrote in message
...
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

Change auto destination in Save As ???
 

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

Change auto destination in Save As ???
 

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

"MartinW" wrote in message
...
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

Change auto destination in Save As ???
 

Bubey

We have decided the default file location under ToolsOptions...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
DTHIS
www.nickhodge.co.uk


"Bubey" wrote in message
...
Where do I find the "File Locations" to make this
change?

"MartinW" wrote in message
...
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

Change auto destination in Save As ???
 

Default template locations must be changed in Word, I can't explain why.
<Tools, <Options, File locations tab.
Lou

"Nick Hodge" wrote:

Bubey

We have decided the default file location under ToolsOptions...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
DTHIS
www.nickhodge.co.uk


"Bubey" wrote in message
...
Where do I find the "File Locations" to make this
change?

"MartinW" wrote in message
...
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