|
GetOpenFilename FileFilter
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 |
GetOpenFilename FileFilter
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 |
GetOpenFilename FileFilter
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 |
GetOpenFilename FileFilter
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 |
GetOpenFilename FileFilter
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 |
| All times are GMT +1. The time now is 04:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com