Hyperlink in Excel

Post Reply
Marc Vanzegbroeck
Posts: 1163
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium
Contact:

Hyperlink in Excel

Post 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

oSheet:Cells( 1 , 2 ):Hyperlinks:Add("C:\Projects\BASF\F13101C.xlsx")


but it doesn't work.
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
User avatar
Enrico Maria Giordano
Posts: 8753
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia
Has thanked: 1 time
Been thanked: 4 times
Contact:

Re: Hyperlink in Excel

Post by Enrico Maria Giordano »

Try this:

Code: Select all | Expand

oSheet:Hyperlinks:Add( oSheet:Cells( 1 , 2 ), "C:\Projects\BASF\F13101C.xlsx" )


EMG
Marc Vanzegbroeck
Posts: 1163
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium
Contact:

Re: Hyperlink in Excel

Post by Marc Vanzegbroeck »

Thank you Enrico,

It's working perfect :D
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
User avatar
MarcoBoschi
Posts: 1071
Joined: Thu Nov 17, 2005 11:08 am
Location: Padova - Italy
Contact:

Re: Hyperlink in Excel

Post 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
Marco Boschi
info@marcoboschi.it
Post Reply