Page 1 of 1

Hyperlink in Excel

PostPosted: Wed Apr 21, 2021 6:40 am
by Marc Vanzegbroeck
Hi,

Does anyone know how to add a hyperlink in a cell via FWH.

I have tried something like
Code: Select all  Expand view
oSheet:Cells( 1 , 2 ):Hyperlinks:Add("C:\Projects\BASF\F13101C.xlsx")


but it doesn't work.

Re: Hyperlink in Excel

PostPosted: Wed Apr 21, 2021 8:27 am
by Enrico Maria Giordano
Try this:

Code: Select all  Expand view
oSheet:Hyperlinks:Add( oSheet:Cells( 1 , 2 ), "C:\Projects\BASF\F13101C.xlsx" )


EMG

Re: Hyperlink in Excel

PostPosted: Wed Apr 21, 2021 8:33 am
by Marc Vanzegbroeck
Thank you Enrico,

It's working perfect :D

Re: Hyperlink in Excel

PostPosted: Fri Mar 15, 2024 11:36 am
by MarcoBoschi
Anybody knows how to how I can return to original cell containing hyperlink after I clicked on it and obviusly moved?
without to create another hyperlink obviously

Have a nice day
Marco