When I first time execute application.filesearch it seeks correctly. but on latter searches it uses prebuilt index and keep looking in that path.even though I have moved file to inner directory. I have to leave the program for 15-20 mins then perhaps it clears it cache and works. I am not getting how to clear its cache. code is like this.pls help
With Application.FileSearch
.NewSearch
.LookIn = PerformanceBook.Path
.SearchSubFolders = True
.Filename = "omsTimes.csv"
.FileType = msoFileTypeAllFiles
If (.Execute(SortBy:=msoSortByLastModified, SortOrder:=msoSortOrderAscending, AlwaysAccurate:=True) <> 0) Then