Excel VBA set a filter for a exact filename using MsoFileDialogPicker

Hi guys,
I've been plying around with this code but cannot achieven what I want:

Please Login or Register  to view this content.

It's the red line that I am trying to use as filter.
I know how this works and yes I can add code to check if the correct file was selected, but that's not it.
I want the filetr to only show the AdminMEDEWERKER.xlsm when a folder is selected.
The problem lies in the part in red, if I place *.xlsm it will show all xlsm files.

Please Login or Register  to view this content.

Anybody an idea?
I also placed this question on the Tech Guy support forum: https://forums.techguy.org/threads/e...ledia.1238235/

Don't think that is possible Hans...
Could narrow down to...

Please Login or Register  to view this content.

Why would you want to have a user select to open only a specific file...
Why not just open the file directly...

Alternatively, you will have to add a snippet to see if the selected item is in fact the required file...

Hi, true, and yes, like I mentioned I have it working but the idea behind this is that the user has to select the folder where the file is located and I thought that the best way is to show only the the file answering the requirements thus that the filer only shows a filename that is the same as the requested file but it does not accept that parameter as a filter, list *.xlsm but if i say *AdminMEDERWERKER*.xlsm or other variations I just get an error.
You see, that once the file is selected I just register the filepath in a setting for later use.
Workarounds enough that work fine, but just trying to find another way.
Will keep this post open for a day or two more and see if some comes up with an idea

Never seen an exact match Dialogue Picker Filter, but yep, would be interesting to see if there is a workaround other than checking if correct file is selected...

You could just use Dialogue to pick the folder and concatenate constant filename.
Then use Dir function to check if file exists in the folder...

But not sure if it's even worth it.

AFAIK - FileDialog Filter can only be used for extension *.xxx or *.* for all.

Not sure if this could help...editing for specific file...
http://www.your-save-time-and-improv...ct-folder.html
http://what-when-how.com/excel-vba/c...-in-excel-vba/

I found some code and played with it

mdwAdminFile is a fulle filename in my case AdminMEDEWERKER.xlsm

Please Login or Register  to view this content.

@sintek: the links do explain things but I have variations of the same. thanks for looking

This seems to work...
I put multiple xlsm files in a folder and only the required one became available as a selection...
In the VBA Editor's Tools menu, click References... scroll down to "Microsoft Shell Controls And Automation"

Please Login or Register  to view this content.

Or without setting reference...

Please Login or Register  to view this content.

Well it works but not with the idea I wanted.
My code does the following, once I run it it now fills a Listbox with the folders where ti's found and all the user has to do is select that item he/she wants

But, I like your solution will do some test with it, thanks again.

Okay...The plot thickens...
So why not just loop all folders and files and if a file is named "AdminMEDEWERKER.xlsm" then add that path to the list for the user then to select...

Please Login or Register  to view this content.

OR, Am I missing something...Why the initial Dialog Picker option...

Of you start in let’s dat G’s root directory the recursieve search takes longer. The Userform works such that the user double clicks the field to open the folder picker and once a folder is selected, click the optionbutton to run the macro and list the found folders in the listbox

Would like to see this pan out...Wanna upload a sample file...

I'll extract that part of the code and paste it in a sample file.

Here's the file the code is extraction took some time
There a Const mwdAdminFile that you can modify the string to a file name you want to look for.

Open the file and double-click the yellow cell

So...I am assuming you have solved your requirement or is there "more than meets the eye"

Yep, it's solved but just wanted to share the solution. The application in which I am using this works.
The reason is simple, the user decides that the file's location has to be modified so he/she selects a new one. There are a certain number of extra files in that same location that if present have to be moved from the old location to the new one.
So the user must be sure that the 'move from' location does indeed cold the main file which is the fixed name, and if that's true then the move routine triggers and all the required files are moved to to 'move to' location.
I'll mark it as solved, thanks for looking and making suggestions.

Glad you got it sorted...Am thankful for this thread as I too have learned new alternatives...

we're never too old to learn