Files list in Application.FileDialog(msoFileDialogFolderPicker)


Hi everyone.

I'd like to show files in a folder when i choose that by  Application.FileDialog(msoFileDialogFolderPicker).

In this moment the Application.FileDialog(msoFileDialogFolderPicker) shows only folders to select but not the files. In another words I'd like to have a view like Application.FileDialog(msoFileDialogFilePicker) for select a folder by checking if it's the right directory.

Thankyou very much.

1 Reply


There is no way to do that. As an alternative, you could display Application.FileDialog(msoFileDialogFilePicker) and instruct the user to select an arbitrary file in the folder they want. You can then extract the folder from .SelectedItems(1)

Of course, this will only work with folders that contain at least one file, it won't let users select an empty folder.