FileSearch Code

[Pedro]

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

 

[Tom Ogilvy]

Pedro,
I gave you sample code to solve this problem in answer to your first posting
of this question. Please stay in the same thread.

Regards,
Tom Ogilvy