ksarveshdureja
New Member
- Joined
- Dec 25, 2016
- Messages
- 2
Hi all,
i want to create a hyperlink to all entries in Column to open a file with the name as in cell.
For Ex:-
<tbody>
</tbody>
and so on, I have appx 1000 such entries.
I want to open these files respectively via hyperlink. Also if i change the values in "NAME" column the the hyperlinks should also get change.
i want to provide a relative path to open files i.e :- ThisWorkbook.Path & "\FORMS\ROBIN.PDF.
Currently i am using :- =HYPERLINK("G:\FORMS"&C1&".pdf",C1&"") to open the file but i want to provide it a relative address so that i can open the files with removable drives as well.
Any help would be really grateful and helpful.
Regards
Sarvesh Dureja
i want to create a hyperlink to all entries in Column to open a file with the name as in cell.
For Ex:-
Name | Link1 | link2 |
JOHN | JOHN.PDF | JOHN.JPG |
ROBIN | ROBIN.PDF | ROBIN.JPG |
JOY | JOY.PDG | JOY.JPG |
<tbody>
</tbody>
and so on, I have appx 1000 such entries.
I want to open these files respectively via hyperlink. Also if i change the values in "NAME" column the the hyperlinks should also get change.
i want to provide a relative path to open files i.e :- ThisWorkbook.Path & "\FORMS\ROBIN.PDF.
Currently i am using :- =HYPERLINK("G:\FORMS"&C1&".pdf",C1&"") to open the file but i want to provide it a relative address so that i can open the files with removable drives as well.
Any help would be really grateful and helpful.
Regards
Sarvesh Dureja