Show Files in Folder using Application.FileDialog(msoFileDialogFolderPicker)

Hi All,

I use VBA code to merge Workbooks within a folder however using Application.FileDialog(msoFileDialogFolderPicker) does not display the internal files within a folder. The File Explorer just displays 'No items match your search'. I have read a few threads on this with no definitive answer.

So my question is, how do you display the files in a folder using Application.FileDialog(msoFileDialogFolderPicker)?

Please Login or Register  to view this content.

Hi Dave,

That only allows you to select one WB in a folder. I am trying to merge all WB's in folder ending with .per file extension

Gives error.

Please Login or Register  to view this content.