How do I Hyperlink to document using filename in cell?

  • Thread starter Thread starter Matt Bennette
  • Start date Start date
M

Matt Bennette

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 spreadsheet.

Can anyone help of the syntax? Or is this impossible

Mank Thanks
 
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!")
 
Genius........

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink using filename 2
Can you hyperlink to a hyperlink? 1
Conditional format cell containing hyperlink 2
Hyperlink - Passing a cell reference 1
Hyperlink Formula Problem 2
how do I drag and fill hyperlinks? 3
Hyplinking Question 2
HYPERLINK using a date in a cell 2

Back
Top