Hyperlinks to pull up PDF files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Hi Dar. With Excel 2003 you can select a cell then go to Insert>Hyperlink
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
 
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,
 
--
Sincerely, Michael Colvin


Dar said:
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,
Click to expand...
 
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.
 
Another way is to use the =hyperlink() worksheet function.

If all the pdf files are in the same folder, put that folder in a cell (say A1).

Then with those values in A2:Axx, you can use a formula like this in B2 (and
drag down):

=hyperlink("file:////" & $a$1 & "/" & a2 & ".pdf", "Click me!")

(you may not need that "/" portion if you included the trailing backslash in
$A$1.)

If all the files are in different folders, you could put the folders in an
adjacent cell and pick it up from there (file name in column A, folder name in
column B, and link in column C):

=hyperlink("file:////" & b2 & "/" & c2 & ".pdf","click me!")

Drag the formulas down the range, too.
 
Back
Top