View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EA EA is offline
external usenet poster
 
Posts: 28
Default Application.Filesearch

Can anyone please advise why the code below worked with Excel 2000 but not
with Excel 2003?

With Application.FileSearch
.Filename = "C:\Test.xls"
If .Execute 0 Then
Workbooks.Open Filename:="C:\Text.xls"
End If
End With