Let a folder named 'test1' stored under "c:\temp". Can I search for files with wildcard (for e.g. c:\temp\test*\) using VBA code. Instead of mentioning test1 can I use test* if test2, test3 folder exist in same location.
Does it have to be VBA? Can you just execute a dir test*.* /s
Go through the following Code: Dim List_Files_In_Directory(10000, 1)
Dim One_File_List As String
Dim Number_Of_Files_In_Directory As LongOne_File_List = Dir$("C:" + "\temp\*.*")
Do While One_File_List <> ""
List_Files_In_Directory(Number_Of_Files_In_Directory, 0) = One_File_List
One_File_List = Dir$
Number_Of_Files_In_Directory = Number_Of_Files_In_Directory + 1
LoopNumber_Of_Files_In_Directory = 0
While List_Files_In_Directory(Number_Of_Files_In_Directory, 0) <> tom
Range("A5").Offset(Number_Of_Files_In_Directory, 0).Value = List_Files_In_Directory(Number_Of_Files_In_Directory, 0)
Number_Of_Files_In_Directory = Number_Of_Files_In_Directory + 1
Wend---
In that we have to mention "Dir$("C:" + "\temp\*.*"). Is there any possibility to mention as te*p instead of mentioned temp
Ad Choices