Home > Default > How to enable hyperlink for a cell in excel thru OLE?

How to enable hyperlink for a cell in excel thru OLE?

November 30Hits:0
Advertisement
Hi,
Iam using OLE2 to download data from an internal table into excel sheet.I want to enable hyperlink for one cell in each line of the excel. Please advice how to go abt it?
Regards,
Shambu

Answers

To hyperlink to the specific sheet in your workbook, you need to first create the sheet and use the parameter #3 of the Hyperlink's ADD method.
Try like this:
*.....Hyperlink to another sheet
  GET PROPERTY OF e_appl 'Range' = e_range
    exporting
    #1 = 'A1'
    #2 = 'A1'.
  GET PROPERTY OF e_activesheet 'Hyperlinks' = e_hyperlink.
  get property of e_work 'Sheets' = e_sheets.
  CALL METHOD OF e_sheets 'Add' = e_work2.
  CALL METHOD OF e_hyperlink 'Add'
    EXPORTING
    #1 = e_range
    #2 = ''
    #3 = 'Sheet2!A1'.   "Targeted Sheet & Cell
*.....Hyperlink to another sheet
Regards,
Naimesh Patel

Read other 5 answers

Tags:

Related Articles

  • How to enable hyperlink for a cell in excel thru OLE?November 30

    Hi, Iam using OLE2 to download data from an internal table into excel sheet.I want to enable hyperlink for one cell in each line of the excel. Please advice how to go abt it? Regards, ShambuTo hyperlink to the specific sheet in your workbook, you nee

  • How do I enable hyperlink within a cell?October 11

    Help, In Numbers 3.5.2 Some cells work when I click on a hyperlink, some don't. How can I format the text to open the URL?  ThanksHi Turftoe, In Numbers 3, Numbers > Edit > Substitutions > Smart Links To change a non-active link to an active URL

  • I have a problem in formatting cells in Excel while using OLE method.November 30

    Hi All, I have a problem in formatting cells in Excel while using OLE method. My requirement is to have certain fields of a cell as text and amount fields should be in number format. How to format a cell in Excel in OLE method of downloading data to

  • Multiple dynamic Hyperlinks in Single CellNovember 30

    My Requirement is similar to http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c3f1cbeb-20b8-4457-9189-3e451c2a5af9/multiple-hyperlinks-in-single-cell-in-ssrs?forum=sqlreportingservices single Data column will be displaying csv values and need

  • Hyperlink from a cell to text in PagesNovember 30

    Hi everyone, Here's my problem, I'd like to create a kind of hyperlink from a cell in a table in a Pages doc, so that the number in the cell automatically copy where I want in the doc. Ex: you want to copy an number  from a cell and paste it in a sen

  • How to change width of cell in Excel using LabVIEW 5.1November 30

    Enable program to change width of cell in Excel 97 file using LabVIEW 5.1.You must have an automation reference to the workbook or the worksheet. Using Application Control pallette find the Property and Invode nodes and wire up the following, cascadi

  • How to download data into one cell of excel in different linesOctober 11

    Hi All, My Report downloads data from R/3 to excel. Now one particular field contains multiple lines, which i needs to download into different lines into that particular cell(of excel). how can i do this. I found one method for this and that is cl_ab

  • How to Update a particular cell in Excel with its specific cell Name?October 11

    {color:#000080}Hi, I have connected my Java program to Excel using JDBC ODBC connection and also I am able to read/write data to Excel currently. In my write code, I have updated the data in particular Excel cells by using conditions in "where"

  • Xcelsius and relative cell in Excel from another documentOctober 11

    Hi, gurus. I have one question about Xcelsius opportunities. Can I use relative cells in Excel document, which as links to cell in another excel document. For example I have two Excel document. At first I use relative cell like this "='\job\[test_1.x

  • How to know the total string length of a range of cell in excel sheetsNovember 30

    Hi,        I am working on Excel automation. I want to read data of collection of cells from excel for that i need to know the total string length in one shot. Can anyone suggest me the answer for thisStill not sure about your requirements, but how a

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.748 s.