View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WhytheQ WhytheQ is offline
external usenet poster
 
Posts: 246
Default What is better: Application.FileSearch or Dir ??

I'm seeing a couple of alternative ways of getting a list of files from
a folder:

1. The original method I'd seen uses a loop and the Dir method
2. A new way I have seen of tackling this problem is to use
Application.FileSearch

Which of the above is best and why?

Regards
Jason.