Macro to make a filenamelist by searching a folder

Giganews Newsgroups
Subject: Macro to make a filenamelist by searching a folder
Posted by:  Snoopy (blaks…@jjuc.no)
Date: Tue, 3 Mar 2009

Hey guys
I want to make a list (in Excel)
This list will contain all the filenames (not the filepath) of all my
files in a spesific folder.
Eg. I want to make a macro that copies each filename i the folder and
paste the names in a list.

I really appreciate if anyone would be kindly to help
Regards Snoopy

Replies