Oops. Sorry, hit the post too soon. Dar, you can set up the hyperlinks for
your users. You only have to do it once. To set up the hyperlink, select
the cell, go to insert hyperlink and browse for the PDF file in the Look
In bar, or its equivalent in 2000, select it and click ok. When your users
click on the cell they will go to the PDF file.
--
Sincerely, Michael Colvin


"Dar" wrote:

I have Excel 2000. Based on your suggestion, a user would have to manually
browse for each pdf file. Isn't there a way to automatically pull up a pdf
file when a user clicks the cell? This way, the user doesn't have to goto
INSERT-HYPERLINK and browse manually for the file.

Thanks,

"Michael" wrote:

Hi Dar. With Excel 2003 you can select a cell then go to InsertHyperlink
and click on the Look In bar and browse to locate your PDF file. If you are
creating the PDF files you could also insert a Hyperlink back to your table
in the original file. HTH
--
Sincerely, Michael Colvin


"Dar" wrote:

I have a column in one of my Excel spreadsheets in which all the cells of
that column will have a unique alpha-numeric value. This value corresponds to
a specific pdf file on one of my folders on the Server. For example, if one
of the cell values is AB123, there will be a pdf file on a different
directory named AB123.pdf.

I want to set this value to be a hyperlink so that when a user clicks it,
its associated pdf file opens.

Can someone please help me with this????

Thanks,