Create Hyperlink in Excel

[Former Member]

Hi,

I have an excel file with different filenames in each cell.

I am trying to hyperlink each cell with the corresponding file path..

I had searched one thread in SDN but my problem is not solved .

Can anyone help me on this with a sample code.

Thanks

Sekhar

[athavanraja]

when you populate the cell content pass it like below

=HYPERLINK("D:\Users\xxx\Desktop\myfile.txt","test link")

[Former Member]

Thanks Raja,

I am not populating cell by cell data but i am using cl_gui_frontend_services=>clipboard_export to paste the data to excel file..

[Former Member]

Hi,

To create hyperlink i had used this

SET PROPERTY OF cells 'Value' =

HYPERLINK("D:\Users\xxx\Desktop\myfile.txt","test link").

but displays a syntax error , does anyone have any idea

Thanks

Sekhar

[Former Member]

Hi,

try this:

SET PROPERTY OF cells 'Value' =

'=HYPERLINK("D:\Users\xxx\Desktop\myfile.txt","test link")'.

regards, Dieter