FileSearch Property

Microsoft Excel Visual Basic

Returns a FileSearch object for use with file searches. This property is available only in Microsoft Windows.

Example

This example creates a FoundFiles object that represents all the Microsoft Excel workbooks in the My Documents folder.

With Application.FileSearch
    .LookIn = "c:\my documents"
    .FileType = msoFileTypeExcelWorkbooks
    .Execute
End With