Question


Flex Technology Inc
IN
Last activity: 6 Nov 2018 20:02 EST
Text to Hyperlink
Hi Team,
Would like to convert the text into hyperlink?
Please!
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!


Pegasystems Inc.
US
If your text is in a Windows Form, you can use a LinkLabel rather than a Label to set a hyperlink. You can set where the link starts within the text and how long the link is. Then in an automation use a Click event on the LinkLabel to start a Process with the FileName property set to the URL you wish to navigate to.


Flex Technology Inc
IN
Hi Buddy,
Thanks!
But the actual requirement looks like:
Eg:- Text is "D:\Folder Name\File Name" [Output from the Activity] which should get convert into hyperlink.
Please..


Pegasystems Inc.
US
How do you plan on using the hyperlink? Where will it be displayed?


Flex Technology Inc
IN
Hi Mitchell,
I wanna store the text as hyperlink in the Spread Sheet for tracking.


Pegasystems Inc.
US
When you say spreadsheet... do you mean in Excel?


Flex Technology Inc
IN
Hi Mitchell,
Yeah.


Flex Technology Inc
IN
Hi Buddy,
Any solution?
Please!


Pegasystems Inc.
US
To clarify, what you are asking is that you want to change the value of a cell in Excel from text to a hyperlink? If so, the Pega Robotics Microsoft Excel connector will not have specific methods to do that out-of-the-box. You can look into writing code to do that using Excel.Interop as the connector is really a wrapper for that and exposes the required objects, although that appears to be unnecessary. I found the article below and you may just be able to change the text that you are inserting into each cell.