How to create a hyperlink from one sheet to another in Excel using ActiveReportsExcelExport.SpreadBuilder

Posted by: zlatka on 4 August 2017, 3:00 pm EST

  • Posted 4 August 2017, 3:00 pm EST

    Dim oXLS As ActiveReportsExcelExport.SpreadBuilder


    Dim oSheet As DDSheet
    Set oXLS = New SpreadBuilder


    Set oSheet = oXLS.Sheets(0)


    oSheet.Name = "My_Name_Here"


    oSheet.Cell(Row, Col).Hyperlink = "[File_Name_Here.xls]" & sSheet_Name_here& "!A1"


    oSheet.Cell(Row, Col).Value = "Click here"





    When I click in the browzer to download + save file, the link in the sheet tries to open an url instead to look in the same file;
    I've tried to substitute the file name with "#", ".", without "[..]" - no result;
    plz help
  • Replied 4 August 2017, 3:00 pm EST

    Hello ,


    You need to use a similar format of hyperlink:


    oSheet.Cell(Row, Col).Hyperlink = "file://c:\\File_Name_Here.xls#" & sSheet_Name_here& "!A1"


    Sergey Romanov.

  • Replied 4 August 2017, 3:00 pm EST

    I've tried with the ful file path, but it is tired to be open like externa file (in new browzer like url) not like link to the same file.


    Is there a way not to explicitely write the full file path?


    Something like this


    oSheet.Cell(Row, Col).Hyperlink = file://#Sheet2!A1


    instead of:


    oSheet.Cell(Row, Col).Hyperlink = file://c:\\Documents\TestFolder\FileTest12.xls#Sheet2!A1


    Thanks in advance,


    Z

  • Replied 4 August 2017, 3:00 pm EST

    Unfortunately, the "internal" links are not supported by spread builder api.


    Sergey Romanov.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels