Creating a hyperlink to a file .

[ksarveshdureja]

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:-


[TABLE="width: 200"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Link1[/TD]
[TD]link2[/TD]
[/TR]
[TR]
[TD]JOHN[/TD]
[TD]JOHN.PDF[/TD]
[TD]JOHN.JPG[/TD]
[/TR]
[TR]
[TD]ROBIN[/TD]
[TD]ROBIN.PDF[/TD]
[TD]ROBIN.JPG[/TD]
[/TR]
[TR]
[TD]JOY[/TD]
[TD]JOY.PDG[/TD]
[TD]JOY.JPG[/TD]
[/TR]
</tbody>[/TABLE]

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

 

[sunny102]

Just remove the drive name=HYPERLINK("FORMS"&C1&".pdf",C1&"") and use like this , example

if I have code.txt file in the same folder with the excel file, I will use =HYPERLINK("code.txt") or =HYPERLINK(A1)

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:-


[TABLE="width: 200"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Link1[/TD]
[TD]link2[/TD]
[/TR]
[TR]
[TD]JOHN[/TD]
[TD]JOHN.PDF[/TD]
[TD]JOHN.JPG[/TD]
[/TR]
[TR]
[TD]ROBIN[/TD]
[TD]ROBIN.PDF[/TD]
[TD]ROBIN.JPG[/TD]
[/TR]
[TR]
[TD]JOY[/TD]
[TD]JOY.PDG[/TD]
[TD]JOY.JPG[/TD]
[/TR]
</tbody>[/TABLE]

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

 

[ksarveshdureja]

Hi there

It worked, I was trying this since evening.Made my day!!!

Very Very Happy!!!!!!!

Really appreciate .

Merry X-Max & Happy New Year