sharathnarayanan
New Member
- Joined
- Apr 4, 2013
- Messages
- 3
=Hyperlink()
tried.. but cannot open the particular file.Please use
Excel Formula:=Hyperlink()
Pdf file name in the folder is "446-02-476-00452-21 SD for Structure 01 - Guard House Tanker Discharge.pdf"Have you tryed with "-", looks like they are missing in your file name?
Book1 | |||
---|---|---|---|
J | |||
14 | file location: | ||
15 | C:\Users\rjpop\Documents | ||
16 | Open My file Please | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J16 | J16 | =HYPERLINK(J15&"\446-02-476-00452-21 SD for Structure 01 - Guard House Tanker Discharge.pdf","Open My file Please") |
Book1 | ||||
---|---|---|---|---|
J | K | |||
14 | file location: | C:\Users\rjpop\Documents | ||
15 | File Name: | 446-02-476-00452-21 SD for Structure 01 - Guard House Tanker Discharge | ||
16 | Extension | |||
17 | Open My file Please | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J17 | J17 | =HYPERLINK(K14&"\"&K15&K16,"Open My file Please") |