Application.FileSearch does not work in Excel 2007.. does anyone have a way of doing this now? Here is my current code.
With Application.FileSearch
.NewSearch
.LookIn = "F:\import\"
.Filename = "moxyaxys.trn"
If .Execute > 0 Then 'File exists
Kill ("F:\import\moxyaxys.trn")
End If
End With
With Application.FileSearch
.NewSearch
.LookIn = "F:\import\"
.Filename = "moxyaxys.trn"
If .Execute > 0 Then 'File exists
Kill ("F:\import\moxyaxys.trn")
End If
End With