Forum Discussion
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 ...
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.