Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have already read and implemented the answer in the following post. Excel: why doesn't "File-> Save As" remember the last directory that you saved a file in However I did not have much faith it was what I was looking for.

If you've ever used OpenOffice you will notice between sessions it remembers the last opened directory for save and open. How can I make excel (word, ect) do the same?

Example:

1) open excel (notice the default file location when you click 'file->open')

2) save the workbook to a different location other than the default, we will call it c:/newloc

3) 'file->open' and you notice the default location you are brought to is c:/newloc

4) close excel

5) open excel (notice the default file location when you click 'file->open' is no longer c:/newloc)

How can I achieve this?

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

I'm afraid you can't, but with Excel 2010 (and maybe 2007, I don't know), you click the File tab, select Recent and then you can click on a map in the Recent Locations list.

share|improve this answer
add comment

Go to Excel options (in 2007 or later, go to the circle in the upper left corner, click Excel Options, go to Save and change the Default file location to whatever you need.

enter image description here

share|improve this answer
    
That will not suffice, I do not want to change the default like this every time I save to a new directory. –  rlemon Aug 20 '11 at 23:11
    
@rlemon I understand. The only thing I could think of is writing yourself a little COM add-in in VB.NET or C# that changes the Application.DefaultFilePath automatically, each time you open up a new file. When I answered, I was envisioning you'd change directories a handful of times throughout your processing, so changing it by hand might have been viable. I'll think some more on it. –  jonsca Aug 20 '11 at 23:51
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.