janderson131
asked on
Setting Default Location for File/Save in Code for Excel
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?
Thank you!
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?
Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think you can do that, but that's a little tricky, because you never know what your user will enter. this might cause unexpected errors. if you generate an automatic filename, you can ensure that the filename meets the standards for a filesystem.
ASKER
OK, thanks!
ASKER