View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BrianB BrianB is offline
external usenet poster
 
Posts: 109
Default FileSearch for a TextorProperty with a wildcard

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.