You don't need a macro.


Let's say your list of files is in column A, for example in A1:
C:\music.xls
with each entry having the path name and file name.


In B1 enter:
=HYPERLINK("file:///"&A1)
and copy down.

This will give you a nice list of "click-able" hyperlinks to the file listed
in column A


--
Gary''s Student
gsnu200712