View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jimbo1[_5_] Jimbo1[_5_] is offline
external usenet poster
 
Posts: 1
Default Help with filename search


I don't know if anyone could help with this. The idea is fairly simple.
At present I have a macro that searches for a file. Each file name is
47 char long and is found using

Set fs = Application.FileSearch
With fs
LookIn = "G:\PUB"
SearchSubFolders = False
Filename =
Out_TkbAwMegVLHRkMfximTWZRvqohpTQOjKNqXN.finish
etc...

Is there a way of of searching using a 'like' statement eg,

filename like Out_TkbAw ??


--
Jimbo1
------------------------------------------------------------------------
Jimbo1's Profile: http://www.excelforum.com/member.php...o&userid=30637
View this thread: http://www.excelforum.com/showthread...hreadid=527100