Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2007

Status
Not open for further replies.

egodette

Technical User
Jun 12, 2002
222
US
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
 
Thanks for the reply. Not sure how all that works. Just looking for a simple code replacement.

 
Thanks for trying..

We don't run Windows Desktop Search. I can't believe that MS screwed this up this bad. Going from 8 lines of code to God knows how many now.

Thanks again.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top