LookIn Property
Applies To
FileSearch object.
Description
Returns or sets the folder to be searched during the specified file search. Read/write String.
Example
This example searches the My Documents folders for all files whose names begin with "Cmd" and displays the name and location of each file that's found.
Set fs = Application.FileSearch
With fs
.LookIn = "C:\My Documents"
.FileName = "cmd.*"
If .Execute > 0 Then
MsgBox "There were " & .FoundFiles.Count & _
" file(s) found."
For i = 1 To .FoundFiles.Count
MsgBox .FoundFiles(i)
Next i
Else
MsgBox "There were no files found."
End If
End With