Search for a File using Wildcards

[tsc35]

I'm having trouble with the code working if I try this slight variant:

Please Login or Register  to view this content.

Basically I want to search for a file that contains specific characters not just a file type. Please note that this is for Excel 2003.

[JBeaucaire]

You mean you want to search for all files with *in. in the title whether they are text files or not? Try:

Please Login or Register  to view this content.

[tsc35]

That does not work either. The problem I think I am having is by having characters after the asterisk the function Filename takes it as a string rather than a wild card indicator.

Please Login or Register  to view this content.

As a note I do want to limit the file type but any file type ".txt" with "in.txt" in it should be found.

[Leith Ross]

Hello tsc35,

You can use the Like operator...

Please Login or Register  to view this content.