View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
August 8 August 8 is offline
external usenet poster
 
Posts: 3
Default FileSearch worked in Excel 97 but not in Excel 2003, how to fix???

The following code worked in Excel 97 but not worked in Excel 2003, why why
why???
and how to fix??? Thanks!!!

Sub test()

With Application.FileSearch
.NewSearch
.SearchSubFolders = True
.filename = "S:\list_file.xls"
.MatchTextExactly = True
If .Execute() 0 Then
MsgBox "found"
Else
MsgBox "not found"
End If
End With

End Sub