Chaning the Excel 2003 Save Path
Posted on 2006-05-03
For Word, there is a nice simple vb function called FileSaveChangeDirectory, which resets all the file paths to look wherever you want.
From what I can tell, in Excel ChDir does much the same. However, when I go to File>Save As in the Excel menu, it always defaults back to where the current document is stored (XLSTART for a new document, as that's where the template document is stored). Is there any way to stop this?
Note 1) If I call CurDir in the before save event, it returns the correct directory. When the save dialog gets called, it's reverted back to the saved file location.
Note 2) On File>Open, the dialog opens in the correct directory. Once the save dialog has been called (even when cancelling it), the CurDir reverts back to the saved file location.
Note 3) Yes, I am using ChDrive as well. No, it's not helping.