I'm trying to set the folder where I want the user to be in before invoking
the open/save dialog. The "ChDir" command isn't changing the current folder.
Can someone tell me the right code to change the current folder?

ChDir "S:\Spreadsheets"

Application.Dialogs(xlDialogSaveAs).Show