Automate hyperlink between a file and Excel 2003

[ReillyC]

I have an excel 2003 spreadhseet that lists the names of adobe files. The filenames are numerical. (i.e. 5696323.PDF, 9863236.PDF, 7896333.PDF. I have over 100 files.
I want to hyperlink each adobe file to the cell where the filename is shown in excel. Is there anyway to automate the process?

Best Regards and thanks for your help in advance.

 

[ETID]

This example formula pasted in cell b2 links cell b2 to a pdf file on an I:\drive of the same name as is in cell A2



=HYPERLINK("I:\"&A2&".pdf", "Go to "&A2&".pdf")