GetOpenFilename FileFilter

Zone · Aug 20, 2006

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

Jim Cone · Aug 20, 2006

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

"Zone" <[email protected]>
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

Zone · Aug 20, 2006

Thanks, Jim. Much better.

NickHK · Aug 21, 2006

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 · Aug 21, 2006

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.