application.filesearch error in excel 2007

[Ramesh]

While running an old macro using application.filesearch I am getting some
maco error in excel 2007. The code is

Set fs = Application.FileSearch
With fs
.LookIn = szRepIn
.Filename = rng.Offset(i, 1).Value
.MatchTextExactly = True
If .Execute(SortBy:=msoSortByFileName,
SortOrder:=msoSortOrderAscending) = 0 Then
rng.Offset(i, 2).Value = "File not found"
End If
End With

The error is being raised at line Set fs = Application.FileSearch

Please help me. I am a newbie to excel.

Thanks
Ramesh

 

[Gary''s Student]

filesearch not supported in 2007. Use fso

 

[Ramesh]

I am newbie to excel, could you please send me a sample code using fso

 

[Gary''s Student]

http://groups.google.com/group/micr...9bf1d5f9a02?hl=en&lnk=gst&q="file+exist"+fso#