How do I Hyperlink to document using filename in cell?
 

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

How do I Hyperlink to document using filename in cell?
 

In A1 & A2:

C:\test\
sample.doc

then in another cell:
=HYPERLINK(A1 & A2)
--
Gary''s Student - gsnu200819

How do I Hyperlink to document using filename in cell?
 

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

Can anyone help of the syntax? Or is this impossible

Mank Thanks

How do I Hyperlink to document using filename in cell?
 

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

Can anyone help of the syntax? Or is this impossible

Mank Thanks