zabiullakhan
Active Member
- Joined
- Aug 30, 2010
- Messages
- 310
how can i use string matching for a file search?
Please help
Please help
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
how can i use string matching for a file search
- Thread starter zabiullakhan
- Start date
zabiullakhan
Active Member
- Joined
- Aug 30, 2010
- Messages
- 310
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 -->
filenames could be
f10_oct10_abc.xls
f10_oct10_def.xls
f10_oct10_xyz.xls
Please help <!-- / message -->
Upvote
0
Ruddles
Well-known Member
- Joined
- Aug 24, 2010
- Messages
- 5,851
- Office Version
- 365
- Platform
- Windows
Look at using the Dir function with wildcards in the file specification. Perhaps you can modify this code to suit:-
Code:
[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]
Upvote
0
Similar threads
- Question
