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

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

 

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

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

 

[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