| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save File to Another Directory, but not change Users File Save location
From Excel toolbar, A user's current "File Save As" location is
\\Server1\UsersName\Documents. After my code saves the open workbook (ActiveWorkbook.SaveAs Filename) to \\Server2\MyName\Documents, the next time the user does "File Save As" from an Excel toolbar, the location seen is \\Server2\Myname\Documents. How can I store the users's current "File Save As" path, run code, and restore the user's current "File Save As" path? In other words, the next time the users selects "File Save As", no directory path changes will be noticed. Thanks, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How change the file location that I save my files to? | Excel Discussion (Misc queries) | |||
| file save error: the file or directory cannot be created | Excel Discussion (Misc queries) | |||
| Automatically save a file in another directory | Excel Discussion (Misc queries) | |||
| Save file, refer filename to cell and change directory | Excel Programming | |||
| get path - save new file - same sub-directory as existing file | Excel Programming | |||
Threaded Mode
