This helps, but doesn't solve the problem.

I have many folders in the desired folder. When the
folder selector is displayed, I want only the folders
which match my filter to be displayed.

For example, if I have the following folders:

C:\Temp\new
C:\Temp\new_1
C:\Temp\new_2
C:\Temp\old
C:\Temp\old_1

When invoking the FileDialog to select a folder, I
first "ChDir C:\Temp", then I want to specify "new* and
display only the "new*" folders in the FileDialog.
The "old*" folders will not be displayed in the
FileDialog. Can this be done?


-----Original Message-----
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.





.