| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I hyperlink from an excel cell to a page in a pdf document | Excel Worksheet Functions | |||
| Hyperlink using filename | Excel Worksheet Functions | |||
| hyperlink filename # | Excel Discussion (Misc queries) | |||
| HELP: Acrobat 7 document via hyperlink in cell | Links and Linking in Excel | |||
| Hyperlink in Excel cell to open PDF document in another directory | Links and Linking in Excel | |||
Linear Mode
