Sam, have a look at the free list files addin here
http://www.realezsites.com/bus/primi...e/products.php

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"SAM SEBAIHI" wrote in message
...

I would like to have a macro that if I execute it, it will copy all the
existing file names from a specified directory into individual cells in
the
sheet. each individual file name will be hyperlinked, if I click on it,
the
file should open (they could be Word or pdf files..etc..)

I really appreciate your help in advance

Thank you,