Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 10th 05, 03:00 PM
Mike
 
Posts: n/a
Default "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   Report Post  
Old June 11th 05, 12:06 AM
Dave Peterson
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to save file to a specific folder? rko281 Excel Discussion (Misc queries) 1 January 25th 05 10:43 PM
How do i save backup copy in a different folder mekraj Excel Discussion (Misc queries) 3 December 17th 04 08:33 PM
how to save to My Documents folder on different PCs Matthew Excel Worksheet Functions 1 December 14th 04 02:49 AM
Save as Default folder Gerry Cornell Excel Discussion (Misc queries) 2 December 13th 04 06:41 PM
cannot save file - folder is read only BigDog Excel Discussion (Misc queries) 1 December 7th 04 11:18 PM


All times are GMT +1. The time now is 11:29 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017