| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vba documentation and filefilter property on os x | Excel Programming | |||
| GetOpenFileName help | Excel Programming | |||
| GetOpenFilename | Excel Programming | |||
| GetOpenFileName bug | Excel Programming | |||
| GetOpenFileName | Excel Programming | |||
Hybrid Mode
