how to extract file names in a file folder

[Mo H]

Hi. I use Windows XP Home Edition. I have a folder with 40 different MS
Word files in it. I need to extract the name of each of those files and put
the names in a table in excel. I have been going to each file name, looking
up its properties, then copying the name of that file and pasting it into
excel. There has to be an easier way to copy ALL the file names. I
appreciate any insight I can get from users.

 

[garfield-n-odie]

See http://word.mvps.org/FAQs/MacrosVBA/InsertFileNames.htm for a
macro that inserts into a Word document the names of all files in
a given folder. You can then copy and paste the file names from
Word into Excel.

If you don't know how to install a macro, then see
http://www.gmayor.com/installing_macro.htm .