Macro to open pdf file

  • Thread starter Thread starter Trev
  • Start date Start date
T

Trev

How can I click on an Excel(2010) cell so that a pdf file opens. I
have a column of numeric values in Excel and I want each cell to link
to a pdf invoice in My Documents. So the cell with value 12345 in
Excel would automatically link to 12345.pdf in My Documents. I know I
can right click and set up a hyperlink to the file but there must be a
"one button" solution.

thanks,
 
Could you use an adjacent cell and a formula that creates the hyperlink?

Like:

=hyperlink("File:////c:/my documents/" & a1 & ".pdf", "Click Me")
 
Could you use an adjacent cell and a formula that creates the hyperlink?

Like:

=hyperlink("File:////c:/my documents/" & a1 & ".pdf", "Click Me")
Thank you; that works perfectly. But it would be nice if I could click
directly on the number without having an extra column.
 
Back
Top