| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Office application version does not match. | Excel Discussion (Misc queries) | |||
| How to use Excel.exe without installing Office in VB Application | Setting up and Configuration of Excel | |||
| Updated to Office 2007 - Saving Excel file error | Excel Discussion (Misc queries) | |||
| Can't access Office Online from Excel Application | Excel Discussion (Misc queries) | |||
| MS Office error message, "a required .DLL file, MSO97.DLL ..." | Setting up and Configuration of Excel | |||
Threaded Mode
