Hi

This should in theory direct all excel's "open" and "save" dialogs to the
desired folder:

ChDrive "C:\Temp"
ChDir "C:\Temp"

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Alan" skrev i melding
...
Is there a way to specify a folder spec when invoking the
FileDialog() to select a folder? I want to display
the "new*" folders and let the user select one of them.

For example:

Set fd = Application.FileDialog(msoFileDialogFolderPicker)
fd.Filters.Add xxxxxxxxx

The "fd.Filters.Add" option appears to work only for file
selection.

Is there another folder selector which supports this?

thanks.