Page 1 of 1

Unable to create hyperlink

Posted: Thu Jun 19, 2014 5:06 pm
by zvasku
Hello,

I have this code in version 4 to create hyperlink to secont sheet (in one workbook):

with XLS[0].Hyperlinks.Add do begin
Col1:=1;
Col2:=1;
Row1:=Row0;
Row2:=Row0;
Address:='''Definice pokladních operací''!C100';
end;

But with version 5, this hyperlnik do not work. If I click on it nothing happens.

Thanks
Zdenek

Re: Unable to create hyperlink

Posted: Fri Jun 20, 2014 8:35 am
by larsa
Hello

Your sheet name is wrong. There shall not be any quotes in the sheet name.

Re: Unable to create hyperlink

Posted: Fri Jun 20, 2014 11:54 am
by zvasku
If I remove quotes, it's still not working.

Re: Unable to create hyperlink

Posted: Sat Jun 21, 2014 11:26 am
by larsa
Hello

I can't reproduce this.

Please provide a code sample that can compile.

Re: Unable to create hyperlink

Posted: Wed Oct 01, 2014 1:58 pm
by zvasku
Sorry to be to late. Lot of another work. Here is code sample

XLS.Insert(1);
XLS.Sheets[0].Name:='Přehled pokladních operací';
XLS.Sheets[1].Name:='Definice pokladních operací';
XLS.Sheets[0].AsInteger[1,10]:=1;
with XLS.Sheets[0].Hyperlinks.Add do begin
Col1:=1;
Col2:=1;
Row1:=10;
Row2:=10;
Address:='''Definice pokladních operací''!C'+IntTOStr(Row+1);
end;