Take a look at the following site:

http://www.ozgrid.com/forum/showthread.php?t=66389

Mark Ivey

"TC Daniel" <TC wrote in message
...
How can I copy (en mass) a folders contents, to show only the names.ext of
the files.
I'll be using these names to create links in excel. I've tried the insert
hyperlink, but it is too slow for all the work here and there are toooo
many
to manually type in.

ie:
\2006
\2007\
abc.pdf
def.pdf
ghi.pdf
xyz.pdf
lmn.xls

My goal is to create an index of all 1500 or so files with working links
to
each file.
Additionally, it would have to be updated weekly with new files.

thanks for your help.