Yes look at the hyperlink function.
If your filenames are contained in say c3, try "C:\test\"&c3 and see if
this gives you the path you require. Obviously you need the appropriate
path, if it looks ok try hyperlink("C:\test\"&c3). You can then copy it
down

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=521696