http://groups.google.com/group/micro...xist%22+ fso#
--
Gary''s Student - gsnu200768
"Ramesh" wrote:
I am newbie to excel, could you please send me a sample code using fso
"Gary''s Student" wrote:
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