If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Save As" folder -- can I default this to the same folder as origi
When I open up an Excel file using Windows Explorer, I sometimes want to use
"Save As" to change the name of the file (eg. new month extension, version 2, etc.) When I do this, Microsoft defaults to a different folder -- it is the folder that I saved my last Excel file, which usually is a totally different folder. Is there a way for me to have SAVE AS default to the same folder that the current file is? Any ideas is greatly appreciated! This has been quite annoying. |
#2
|
|||
|
|||
It sounds like you're using xl97. MS changed the behavior to offer to save to
the folder that contained the original with xl2k. Maybe you can upgrade??? Or if it's just that single workbook, you can have a macro that does the changing of folder. Option Explicit Sub testme01() Dim mySavedPath As String mySavedPath = CurDir ChDrive ThisWorkbook.Path ChDir ThisWorkbook.Path Application.Dialogs(xlDialogSaveAs).Show ChDrive mySavedPath ChDir mySavedPath End Sub If your file is on a Network path (not mapped), you can use this instead. (In fact, this works no matter what.) Option Explicit Private Declare Function SetCurrentDirectoryA Lib _ "kernel32" (ByVal lpPathName As String) As Long Sub ChDirNet(szPath As String) Dim lReturn As Long lReturn = SetCurrentDirectoryA(szPath) If lReturn = 0 Then Err.Raise vbObjectError + 1, "Error setting path." End Sub Sub testme02() Dim mySavedPath As String mySavedPath = CurDir ChDirNet ThisWorkbook.Path Application.Dialogs(xlDialogSaveAs).Show ChDirNet mySavedPath End Sub Mike wrote: When I open up an Excel file using Windows Explorer, I sometimes want to use "Save As" to change the name of the file (eg. new month extension, version 2, etc.) When I do this, Microsoft defaults to a different folder -- it is the folder that I saved my last Excel file, which usually is a totally different folder. Is there a way for me to have SAVE AS default to the same folder that the current file is? Any ideas is greatly appreciated! This has been quite annoying. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook displays two identical Personal Folders | Paul S | Installation & Setup | 36 | October 16th, 2007 04:20 PM |
24th time to try this post: Make Folder List Default view in Nav P | - BF | Installation & Setup | 0 | November 16th, 2004 06:14 PM |
4th time to try this post: Make Folder List Default view in Nav Pa | - BF | Installation & Setup | 0 | November 16th, 2004 06:14 PM |
changing default Sent Items folder | LAF | General Discussion | 3 | August 24th, 2004 09:18 PM |
Save Changes to Normal.dot? | Leonard M. Wapner | New Users | 3 | May 18th, 2004 02:40 PM |