hi everyone..
can somebody give me some code to perform file search. i use vb editor in ms excel.
i had try this..

with
.filesearch = "c:\my document\wan"
.filetype = ......".xls : .pdf"
.filename = textbox.text
execute
end with

i want to search for .xls and .pdf file which i locate them in a folder namely "wan".
i have a textbox, user may enter the path name of the file.. when they click search button, it will directly check file availability in "wan" folder.

when i run above code, .filename, . filesearch, .filetype appear to be error. may i know why? any suggestion? thank you very much for your time..

the "with" statement needs the object you want to work with

Marco

thanks for the reply..

With Application.FileSearch
    .LookIn = "C:\My Documents"
    .SearchSubFolders = True
    .Filename = Code.Text
    .MatchTextExactly = True
    .FileType = msoFileTypeExcelWorkbooks

    If .Execute() > 0 Then
        MsgBox "There were " & .FoundFiles.Count & _
            " file(s) found."
        For i = 1 To .FoundFiles.Count
            MsgBox .FoundFiles(i)
            fileToOpen = Application _
            .GetOpenFilename = FileName
                If fileToOpen <> False Then
                    MsgBox "Open " & fileToOpen
                End If

        Next i
    Else
        MsgBox "There were no files found."
    End If
End With

i had try this one.. i can displays the standard Open dialog box and gets a file name from the user but i cannot open any files.
how to directly open the file (excel workbook)? can i make this possible? or any other suggesstion. i need respon from anybody, asap..thanks a lot..