How to Make "Save As" Default to Last

  • Thread starter Thread starter myrrh
  • Start date Start date
M

myrrh

How do I make the "Save As" default to the folder where I saved the
previous Excel file?

Thanks!
 
If you open an existing file in xl97 and do a file|saveAs, then excel will go
to the folder that's specified in tools|options|general tab|Default file
location.

If you open an existing file in xl2k (and above) and do a file|SaveAs, then
excel will go to that folder that contained the original file.
 
Or, you could also choose to go *backwards* to XL5.0 and get that nice same
functionality as the newer versions.<bg>
 
That is for saving an existing file. What I am doing is creating the
saving new files. I have a need to do this repeatedly and would like t
be able to have the "Save as Type" default to "Workbook" and the folde
default to a particular folder. Is there a way to do this
 
Yeah, I kind of thought that's what you were asking.

How about an alternative:

If you're using xl2002 (or higher), you can add your favorite folders to the
lefthand side of file|open and file|saveas dialog.

Point to your folder (inside the file|SaveAs dialog),
then Tools|Add to "My Places"


Then you'll have a quick shortcut to that folder. (And you can add shortcuts to
other folders in that favorite place, too.)

And if you're not using xl2002+, MS has a COM addin that's called Places.exe
that allows you to update the places list.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q253338
INFO: Office Developer Samples and Tools Available for Download (Q253338)

Scroll about halfway down. Might make your life a little easier.

========
I guess you could write a application event that monitored every SaveAs you
did...

If you want to try that, you can read more about those application events at
Chip Pearson's site:
http://www.cpearson.com/excel/AppEvent.htm
 
Back
Top