ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Application file search error in Office XP (https://www.excelbanter.com/excel-programming/280224-application-file-search-error-office-xp.html)

No Name

Application file search error in Office XP
 
I have this vba and it will not result in the file that
I've searching. I'ved used this code in MS Excel 97 and
worked fine. Recently I upgraded to Office XP (SP2) and
got the error.


Dim fsoFileSearch As FileSearch
Set fsoFileSearch = Application.FileSearch

With fsoFileSearch
.NewSearch
.LookIn = "c:\Pres\Reports"
.Filename = "*.xls"
.SearchSubFolders = False
If .Execute(SortBy:=msoSortByFileName, _
SortOrder:=msoSortOrderDescending) 0 Then



All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com