GetOpenFilename FileFilter

[Zone]

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]

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]

Thanks, Jim. Much better.

 

[NickHK]

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]

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.