I am using Microsoft Office 2010 and Windows 7 on a Dell PC. I am opening a bunch of MSWord files one at a time, copying data tables therein, pasting the data into Excel and saving the Excel files as comma delimited text files. I am creating a separate Excel file for each MSWord file.
The path to the folder containing the saved comma-delimited files is quite long, something like this:
c:\users\me\aa\bb\cc\dd\ee\
Every time I open Excel and save a new comma-delimited file I have to re-navigate the entire path (c:\users\me\aa\bb\cc\dd\ee).
In the past Windows seemed to remember the last used path, saving a lot of tedious key-strokes. In fact, I think Windows did this for me as recently as last week, albeit on a different computer.
Can I apply a setting in Windows somewhere asking it to offer the last used path as a default when saving files so I do not have to re-navigate the entire directory structure to save each new comma-delimited file? If I can, how so? Where is the option for specifying that setting?
Thank you for any help.
Best Answer
That implies you quit Excel after each save. In that case Excel will revert to the default file location. To keep the current location, do not quit. Instead, close the spreadsheet only and Excel will remember the location from the last save.
Alternatively, in Excel go to Tools > Options and click the General tab (I'm using Office 2003 - 2007 and later may be slightly different). You can specify the default file location there.