Gets or sets the folder to be searched during the specified file search. Read/write
Syntax
expression.LookIn
expression A variable that represents a FileSearch object.
Example
This example searches the My Documents folders for all files that begin with "Cmd" and displays the name and location of each file that's found.
| Visual Basic for Applications
|
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
|
120 acp acp120 display the location of found files find files by looking in a directory look look in look in directories to search for a file Look In Property lookin lookin property ofv ofv120 olv olv120 pbv pbv120 pjv pjv120 ppv ppv120 sdv sdv120 set the directory to search during a file search vov vov120 wdv wdv120 xlv xlv120