ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why doesn't this work in Win 2K? (https://www.excelbanter.com/excel-programming/334479-why-doesnt-work-win-2k.html)

Ken Loomis

Why doesn't this work in Win 2K?
 
The following works well in Win 98 & Win XP, but causes Excel to crash &
quit in Win 2K:

With Application.FileSearch
.NewSearch
.FileName = "*.xls"
.LookIn = MyFilePath
.SearchSubFolders = True
.TextOrProperty = "BuildStreetsReports"
.MatchTextExactly = False
.Execute


Can anyone tell me why?

TIA,
Ken



NickHK

Why doesn't this work in Win 2K?
 
Ken,
Excel2K & W2K works fine.

NickHK

"Ken Loomis" wrote in message
...
The following works well in Win 98 & Win XP, but causes Excel to crash &
quit in Win 2K:

With Application.FileSearch
.NewSearch
.FileName = "*.xls"
.LookIn = MyFilePath
.SearchSubFolders = True
.TextOrProperty = "BuildStreetsReports"
.MatchTextExactly = False
.Execute


Can anyone tell me why?

TIA,
Ken





okaizawa

Why doesn't this work in Win 2K?
 
Hi,
FileSearch uses Index Service or Office Find Fast.
how about turning on/off the services?

OFF97: Microsoft Office 97 Programs FileSearch Fails on a Microsoft
Windows 2000-based Computer
http://support.microsoft.com/default...b;en-us;259738

Descripton of the new Search feature in Office XP
http://support.microsoft.com/kb/282107/EN-US/

Description of the Find Fast Indexer utility in Office 2000
http://support.microsoft.com/kb/205289/EN-US/

--
HTH
okaizawa

Ken Loomis wrote:
The following works well in Win 98 & Win XP, but causes Excel to crash &
quit in Win 2K:

With Application.FileSearch
.NewSearch
.FileName = "*.xls"
.LookIn = MyFilePath
.SearchSubFolders = True
.TextOrProperty = "BuildStreetsReports"
.MatchTextExactly = False
.Execute


Can anyone tell me why?

TIA,
Ken



All times are GMT +1. The time now is 10:04 PM.

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