Posted to microsoft.public.excel.programming

WhytheQ

external usenet poster

Posts: 246

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Application.FileSearch	Cleberton(Brazilian)	Excel Discussion (Misc queries)	2	October 26th 09 01:21 PM
Application.Filesearch	EA	Excel Programming	3	August 17th 06 10:07 AM
Application.FileSearch malfunction??????	rznante	Excel Programming	2	June 6th 06 04:52 PM
Application.FileSearch challenge	Robin Clay[_4_]	Excel Programming	3	March 3rd 06 08:56 PM
VBA Application.FileSearch	Roger Frye	Excel Programming	0	March 5th 04 04:07 AM

All times are GMT +1. The time now is 08:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us