topic RE: Hyperlink gets changed in excel in University Forum

Hyperlink gets changed in excel

pracmathur — Mon, 05 Jul 2021 14:37:00 GMT

Hi All,

I have created an excel VBO to add hyperlink to a file saved in some shared drive. Using this VBO, I am adding hyperlink in excel file which is saved in some folder A. When I move this file to some other folder B, the hyperlinks gets changed.

See below picture- This is the hyperlink which I am getting in the file before I move it to another folder.

See below picture- This is the hyperlink which I get when I move the file to a folder.

------------------------------
REGENT PARK
Consultant
Personal
Asia/Kolkata
------------------------------

RE: Hyperlink gets changed in excel

EmersonF — Mon, 05 Jul 2021 16:37:00 GMT

Hey, see if it helps you.
Need active hyperlink in results element in VBO | Blue Prism University

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55 (081) 98886-9544
If my answer helped you? Mark as useful!
------------------------------

RE: Hyperlink gets changed in excel

ramprasad.gajula — Mon, 05 Jul 2021 17:36:00 GMT

Hi Regent,

Use the below excel formula in set cell value action.

=HYPERLINK("File Location", "Friendly Name")

------------------------------
Ram Prasad Gajula
Software engineer
EY
Bangalore
+919704497828
------------------------------

RE: Hyperlink gets changed in excel

pracmathur — Mon, 05 Jul 2021 17:43:00 GMT

Hi Ram,

Could you please share one example.
I couldn't understand the syntax properly.

------------------------------
REGENT PARK
Consultant
Personal
Asia/Kolkata
------------------------------

RE: Hyperlink gets changed in excel

EmersonF — Mon, 05 Jul 2021 17:48:00 GMT

=HYPERLINK("http://blueprism.com")

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55 (081) 98886-9544
If my answer helped you? Mark as useful!
------------------------------

RE: Hyperlink gets changed in excel

pracmathur — Mon, 05 Jul 2021 17:54:00 GMT

I am using below code for adding hyperlink

------------------------------
REGENT PARK
Consultant
Personal
Asia/Kolkata
------------------------------

RE: Hyperlink gets changed in excel

EmersonF — Mon, 05 Jul 2021 18:10:00 GMT

@pracmathur , congrats, but I believe it's a rework if the set cell value action already does the function

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55 (081) 98886-9544
If my answer helped you? Mark as useful!
------------------------------

RE: Hyperlink gets changed in excel

pracmathur — Mon, 05 Jul 2021 19:43:00 GMT

@Emerson Ferreira...
I think I was stupid to create this code instead of using set value action...
Hyperlink function worked. Thanks ☺️

------------------------------
REGENT PARK
Consultant
Personal
Asia/Kolkata
------------------------------