There's a couple of routines in this thread:

http://groups.google.co.uk/group/mic...a93c6e6 b7fca

or

http://snipurl.com/i03g

S.G.Pillai wrote:

I am having nearly 5000 files in a folder and is it possible for me to just
import the file names in to excel format from the particular folder.
any help appreciated
thanks in advance

--

Dave Peterson