Excel macros to convert text into hyperlink


Can anyone help me to create excel macros ? Need to convert selected column’s text into hyperlink with name “pdf” for all.

Hi @pari_patel

For your case, you can try with vb.net/c#/macros to create the hyperlink. Apart from this, you can try the activities provided by @balupad14 . He had designed the activity for adding the hyperlink.

Nived N

1 Like

Thanks @NIVED_NAMBIAR for sharing. I will definitely try this and let you know. I dis VB code for macros but how should I use this created macro for each new excel coming every day ?