Changing filters in a dialog box?

Hello,

The file filter in the following code works well. When I open the dialog box I see all the *.txt file types....

Please Login or Register  to view this content.

However, the new SelectFiles() function needs to be flexible enough so that I can pass it a variable and based on that variable
I can alter the file filter. Something like this:

Please Login or Register  to view this content.

The above gives a runtime error 5 when FilterType = 2 ?

However, the above works if I do:

Please Login or Register  to view this content.

But I need it to filter files only starting with "User" ... so all files like : "User*.h" ???

Is there straight forwards approach to this?

Thanks all in advance for your help!
Rn

Not using msoFileDialogFilePicker, unfortunately.

You can read the files of a selected directory and add them to a list on a userform if they meet your needs eg

Please Login or Register  to view this content.

and use code like this on the userform:

Please Login or Register  to view this content.

Originally Posted by Bernie Deitrick

Not using msoFileDialogFilePicker, unfortunately.

You can read the files of a selected directory and add them to a list on a userform if they meet your needs eg

Please Login or Register  to view this content.

and use code like this on the userform:

Please Login or Register  to view this content.

Hi Bernie,
For me it's quite an overkill of code ...
I'm sort of new to VBA and wanted to keep it as
simple as possible.

One thing though, the only reason I wanted to
filter the files is because I wanted the user to pick
any file he sees but wanted to limit the files.
in reality all I need is the path to the folder !
I really strip off the User.h file and I use the path of
the folder.

So with my original code can I just go about
getting only the path name without the user picking a file?

For eample I saw this:

http://software-solutions-online.com/2014/03/13/vba-save-file-dialog-filedialogmsofiledialogsaveas/

But what does this mean:

strPath = _

thanks
for your reply
Rn

You can get the path from the file name like this - but they do have to select a file to get a returned value.

Please Login or Register  to view this content.