Hyperlink in Excel

Hyperlink in Excel

Postby Marc Vanzegbroeck » Wed Apr 21, 2021 6:40 am

Hi,

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

I have tried something like
Code: Select all  Expand view  RUN
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
Marc Vanzegbroeck
 
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

Re: Hyperlink in Excel

Postby Enrico Maria Giordano » Wed Apr 21, 2021 8:27 am

Try this:

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


EMG
User avatar
Enrico Maria Giordano
 
Posts: 8718
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia

Re: Hyperlink in Excel

Postby Marc Vanzegbroeck » Wed Apr 21, 2021 8:33 am

Thank you Enrico,

It's working perfect :D
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Marc Vanzegbroeck
 
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

Re: Hyperlink in Excel

Postby MarcoBoschi » Fri Mar 15, 2024 11:36 am

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
User avatar
MarcoBoschi
 
Posts: 1065
Joined: Thu Nov 17, 2005 11:08 am
Location: Padova - Italy


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 43 guests