Setting Default Location for File/Save in Code for Excel
Posted on 2004-10-21
I would like to set the File/Save path for a spreadsheet. I run several macros, then I prompt the user to save the modified version of the file. There are several iterations of this process, each compiles different data and needs to be saved with a slightly different name, but in a similar location. THe path is nested a bit deep. I don't want to change the general Excel default file location.
Can I present the user with an opened File/Save As dialog box, where the path has been set and they just need to modifiy the file name a bit then click save?