how can i use string matching for a file search

[zabiullakhan]

how can i use string matching for a file search?

Please help

 

[GlennUK]

Do what with string matching? For what file search?

 

[zabiullakhan]

i want to search files names contain "f10_oct10" as a part of the file name and copy those files in a different folder.

filenames could be
f10_oct10_abc.xls
f10_oct10_def.xls
f10_oct10_xyz.xls
Please help <!-- / message -->

 

[Ruddles]

Look at using the Dir function with wildcards in the file specification. Perhaps you can modify this code to suit:-

[FONT=Courier New][SIZE=1]Option Explicit[/SIZE][/FONT]
[FONT=Courier New][SIZE=1][/SIZE][/FONT] 
[FONT=Courier New][SIZE=1]Sub Demo()[/SIZE][/FONT]
[FONT=Courier New][SIZE=1][/SIZE][/FONT] 
[FONT=Courier New][SIZE=1]Dim FileSpec As String
Dim Filename As String
Dim OldFolder As String
Dim NewFolder As String[/SIZE][/FONT]
[FONT=Courier New][SIZE=1][/SIZE][/FONT] 
[FONT=Courier New][SIZE=1]FileSpec = "test*.txt"
OldFolder = "c:\temp\temp1\"
NewFolder = "c:\temp\temp2\"[/SIZE][/FONT]
[FONT=Courier New][SIZE=1][/SIZE][/FONT] 
[FONT=Courier New][SIZE=1]Filename = Dir(OldFolder & FileSpec)
Do Until Filename = ""
  FileCopy OldFolder & Filename, NewFolder & Filename
  Filename = Dir
Loop[/SIZE][/FONT]
[FONT=Courier New][SIZE=1][/SIZE][/FONT] 
[FONT=Courier New][SIZE=1]End Sub
[/SIZE][/FONT]