RE: How do I Hyperlink to document using filename in cell?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Genius........

Thank you, I tried so many combinations was starting to get a little cross.

"~L" wrote:

The trick here is that the path must be text and you can make use of the
ampersand & to join cells into your string.

Where A1 contains the filename:

=hyperlink("C:\YourFilePath\Here\" &A1, "Follow Me!")

If you don't want to type the extension into A1,

=hyperlink("C:\YourFilePath\Here\" &A1 &".xls", "Follow Me!")

"Matt Bennette" wrote:

I am trying to use the =hyperlink formula in conjunction with a cell
reference to open a word document.

All the files share a common path to a folder, that contains files that
correspond to a list in an excel spread***.

Can anyone help of the syntax? Or is this impossible

Mank Thanks
.

Quantcast