Thread: loop thru folder looking for files with date code in name
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
John Keith John Keith is offline
external usenet poster
  
Posts: 172
Default loop thru folder looking for files with date code in name
On Mon, 28 Sep 2009 08:18:02 -0700, Patrick Molloy
wrote:

good spot re my typo - my keyboard does have a habit of doing that!

My keyboard does that a LOT also.

you could also use an IF statement

IF RIGHT(sFilename,12) = sData & ".xls" Then

worth testing large folders to see which is faster, this or the INSTR()

Unfortunately the filenames are searching are more complicated than
you assumed.

Thanks for the tips.



John Keith

Reply With QuoteReply With Quote