msoFileDialogFilePicker: How to show csv and no other file types

[ninmjj]

Hi,

I have a great little macro that works perfectly with one small frustration.

I would like my Application.FileDialog(msoFileDialogFilePicker) to only show subfolders and csv files.
Normally, this works, but if the folder contains shortcuts to other files (even non-csv files), the icons for these shortcuts appear.


Here is my code:

Please Login or Register  to view this content.

Thanks you in advance for your help.

[Leith Ross]

Hello ninmjj,

This should do what you want and will less code...

Please Login or Register  to view this content.

[ninmjj]

Hi Leith,
Thank you for your reply, but this does not resolve my issue.

In the folder of my choice, I would like to only see subfolders and .csv files.
Your method (and mind) shows shortcuts to other files and folders. I don't want shortcuts to appear.

I only want to see a list of subfolders and below it a list of csv files that are in that directory.

Thanks, though.