FileFind Property

Applies To

Application object.

Description

Returns a FileFind object that can be used to search for files using either an absolute or relative path. Read-only.

Note property is available only in Microsoft Office for the Macintosh.

Example

This example displays the names of all files in the My Documents folder that begin with "New."

With Application.FileFind
    .FileName = "New*.*"
    .LookIn = "C:\My Documents"
    .Execute
    For i = 1 To .FoundFiles.Count
        MsgBox .FoundFiles(i)
    Next
End With