How do I Hyperlink to document using filename in cell?

[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

 

[Gary''s Student]

In A1 & A2:

C:\test\
sample.doc

then in another cell:
=HYPERLINK(A1 & A2)

 

[~L]

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]

Genius........

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