| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.filesearch error in excel 2007
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filesearch error in Excel 2007 | Excel Programming | |||
| Application.FileSearch in 2007 | Excel Programming | |||
| replacement for Application.FileSearch in 2007 | Excel Programming | |||
| What is better: Application.FileSearch or Dir ?? | Excel Programming | |||
| Application.FileSearch crashed Excel in Windows 2K | Excel Programming | |||
Hybrid Mode
