Using the OPENFILENAME structure to set a filter

[fritesmodern]

How can I use the OPENFILENAME structure to create a filter including and excluding certain keywords?. This could be an example. "*KEYWORD1*.pdf" excluding results containing KEYWORD2; This filter would retrieve all the pdf documents containing the KEYWORD1 keyword in their name excluding all those files containing the KEYWORD2 keyword in their name. Is there any way to make this filter case sensitive?



Let me emphasize that I would like to use the OPENFILENAME for this purpose since I already have a subroutine which uses this function. However I am open to other alternatives if the OPENFILENAME cannot do the job.

Thanks for your help.

[ItsMe]

I do not have experience using OPENFILENAME, but I will guess using wildcards for file name parts is not an option. You will probably be limited to a Filter of file extensions. So you could filter for *.PDF and enumerate all the names of the PDF files within a given folder. As you iterate the names of the filtered PDF files you could check to see if your string exists using the InStr() function, Left() function, etc.