Thank you, Nick. I thought about backwards compatibility, but the
FolderPicker is so much easier to use, I think I'll go with that. I'll
look at the link, though.
Regards, James
NickHK wrote:
If you need to support versions of Excel before 2002 (??), then
msoFileDialogFolderPicker is not available.
Look into using the SHBrowseForFolder API.
http://vbnet.mvps.org/code/browse/browseadv.htm

NickHK

"Zone" wrote in message
ups.com...
Thanks, Jim. Much better.

Jim Cone wrote:
Try...
Application.FileDialog(msoFileDialogFolderPicker). Show
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Zone"
wrote in message
I want to use the GetOpenFilename method to show me a list of the
subfolders in the current path. I've forgotten how to specify the file
filter to show subdirectories only. TIA, James