FiveTech Software tech support forums

When I click on cell from the worksheet named "MASTER" that has a hyperlink to another cell in "DETAILS" worksheet I found the cell in the bottom of the video. This almost always happens. Is it possible to scroll the worksheet so that when ...

... := [=COLLEG.IPERTESTUALE("#UNO!A1";"MARCO")] Note: Some sites: (https://pt.excelfunctions.eu/) translate COLLEG.IPERTESTUALE (HYPERLINK) to HIPERLIGAÇÃO that gives ERROR. The correct is (here in Brazil): oAs2:Range("A1"):value := [=HIPERLINK("#UNO!A1";"MARCO")] ...

In this way
oAs2:Range("A1"):value := [=COLLEG.IPERTESTUALE("#UNO!A1";"MARCO")]

Hi, I have to create an hyperlink from cell A1 of sheet2 to cell A1 of sheet1 If I click on the cell "MARCO" I want to go to the cell "BOSCHI" When I click on it I have this alert (italy) "Indirizzo del sito non ...

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

in a normal Xbrowse table I would like to have the possibility of displaying a hyperlink text ( TUrlLink) in a field, but not all the records, just the ones I want. why do I want to have a Hyperlink text? because the final user could click on it and view information ...

cTemp := StrTran(cTemp, "<a href=", "{\field{\*\fldinst{HYPERLINK ") cTemp := StrTran(cTemp, "</a>", "}}{\fldrslt ") cTemp := StrTran(cTemp, ">", "}}") I see this but it is not clickable ...

Thank you Enrico,

It's working perfect

Try this:

Code: Select all  Expand view

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

EMG

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.

Is it also possible to know the location when you do a doubleclick?
Since when you swipe or zoom, the locations are different. Mayme a hyperlink would me nice

Thanks

It works.

Regards.

ACWoo

... = "Doe"   oSheet:Range( "B2" ):Value = "John"      oSheet:Range( "D4" ):Value:='=HYPERLINK("#Sheet1!A12","Test1")'   // insert correct full path for hyperlinked file   oSheet:Range( "A10" ):Value ...

Code: Select all  Expand view

cText := ""
TEXT INTO cText
=HYPERLINK("[D:\\MyExcelFile.xlsx]'Sheet1 A'!C5","CLICK HERE")
ENDTEXT

Now use the cText on the cell

Hi

Thanks

I get :

Syntax error at 'SHEET1'

Regards

ACWoo
Bcc582
FWH