filesearch not supported in 2007. Use fso
--
Gary''s Student - gsnu200768


"Ramesh" wrote:

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