View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Pedro[_4_] Pedro[_4_] is offline
external usenet poster
 
Posts: 11
Default File Search code

I already done it but the result is the same


"Abdul Salam" wrote in message
...
Hi,

Try to add file extention too


Abdul Salam


-----Original Message-----
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"
.MatchTextExactly = True
.FileType = msoFileTypeExcelWorkbooks
End With



.