Thread: FileSearch Code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pedro[_4_] Pedro[_4_] is offline
external usenet poster
 
Posts: 11
Default FileSearch Code

Hi
I am using the following code to open an excel file, but it is opening not
the esact file Run.xls but
another one ppp-Run.xls. What Change should I do? Thanks
With Application.FileSearch
.NewSearch
.LookIn = "C:\My Documents"
.SearchSubFolders = True
.FileName = "Run.xls"
.MatchTextExactly = True
.FileType = msoFileTypeExcelWorkbooks
End With