Hyperlink gets changed in excel

[pracmathur]

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
------------------------------

[EmersonF]

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!
------------------------------

[ramprasad.gajula]

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
------------------------------

[pracmathur]

Hi Ram,

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

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

[EmersonF]

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

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

[pracmathur]

I am using below code for adding hyperlink

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

[EmersonF]

@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!
------------------------------

[pracmathur]

@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
------------------------------