I'm trying to search through files and return the filenames of those files that contain a particular text. Well, I can do this just find if I know exactly the text I'm looking for but I don't. (I only know for certain the last 8 characters of a 14 character string). I've tried wildcards and setting .MatchTextExactly = False, but I still can't get this to work. Does anyone have any advice that could help me out with this? Much appreciated

Have a look at the VB Instr() function which will allow you to search
for your 8 characters. If it returns a number more than zero
...........


Regards
BrianB
================================================== ============

myensr wrote in message ...
I'm trying to search through files and return the filenames of those
files that contain a particular text. Well, I can do this just find if
I know exactly the text I'm looking for but I don't. (I only know for
certain the last 8 characters of a 14 character string). I've tried
wildcards and setting .MatchTextExactly = False, but I still can't get
this to work. Does anyone have any advice that could help me out with
this? Much appreciated.