topic-40286

Board index FiveWin for Harbour/xHarbour Hyperlink in Excel

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Hyperlink in Excel
Posted: Wed Apr 21, 2021 06:40 AM

Hi,

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

I have tried something like

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

but it doesn't work.

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: Hyperlink in Excel
Posted: Wed Apr 21, 2021 08:27 AM

Try this:

Code (fw): Select all Collapse

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

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Re: Hyperlink in Excel
Posted: Wed Apr 21, 2021 08:33 AM

Thank you Enrico,

It's working perfect

MarcoBoschi

Posts: 1091

Joined: Thu Nov 17, 2005 11:08 AM

Re: Hyperlink in Excel
Posted: 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

Marco Boschi
info@marcoboschi.it

FiveTech Support Forums

Continue the discussion