Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This is driving me crazy.
I use the following to search for files that are ".xls" files and contain a sub name in the VBA: MyFilePath is the path to the My Documents folder on whatever system this runs on StartTime = Time With Application.FileSearch .NewSearch .FileName = "*.xls" .LookIn = MyFilePath .SearchSubFolders = True .TextOrProperty = "BuildStreetsReports" .MatchTextExactly = True .Execute EndTime = Time MsgBox ("Done searching. It took " & (EndTime - StartTime) * 24 * 60 & " minutes") On my Windows XP system that search takes les than 20 seconds. But when I run it on my Windows 98 system, it can take up to 10 minutes and sometimes just hangs and won't come back at all, even if I let it run for an hour. I am beginning to think there is something wrong with Windows or my Office installation. Has anyone else ever had this kind of problem with FileSearch, or have any ideas or suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
file search or search files | Excel Discussion (Misc queries) | |||
Xl search problem | Excel Discussion (Misc queries) | |||
Turning a text file name into a search and linking the file as a hyperlink | Excel Discussion (Misc queries) | |||
Problem with a search | Excel Programming | |||
Macro to search from one file & place on another file. | Excel Programming |