How to remove hyperlink in excel

Help
1

can any one tell me how to remove hyperlink for any url which is stored in excel

2

Hi @supriyad,

You can record a Macro for this and run the same from UiPath this will remove all the hyperlinks.

Just make sure that your Excel should be Macro enabled while your are running macro.

Thanks,
Prankur

1 Like
3

can you tell me how to do macro enable

4

Record your macro. Then click on Save As option, then select Save as Type as Excel Macro-Enabled Workbook

image

Thanks,
Prankur

5

can you help me little bit more about what macro code should i have to write for this removing hyperlink

6

Record it if you want to remove all hyperlinks. Start recording Select All > Right Click > Remove Hyperlink Stop macro and save it. Then use execute macro from UiPath. See these

Thanks,
Prankur

1 Like
7

hi @PrankurJoshi what ever solution you have given to me is also applicable for making hyperlink to url as well ???

8

Ohh yes of course you can do that as well

1 Like
9

can you give me any example of macro??? @PrankurJoshi

10

do u have any example file of macro ???so please can you share with me??

11

Hi @supriyad,

I have uploaded a custom activity to remove the hyperlinks from the excel sheet with selected range of cells.

Regards
Balamurugan.S

13

Hi @balupad14, The ‘Hyperlink Remove’ activity is not working for me as well. It doesn’t throw any error and doesn’t delete the hyperlinks as well. Iam not able to attach any files to the post as Iam new user. My excel have a cell with data as “=‘https://xyz-my.sharepoint.com/personal/gt_xyz_ae/Documents//2020/[TaxInvoices.xlsm]1.Trn’!$N$2877” and my xaml file have only one activity i.e ‘Hyperlink Remove’. Please help

14

Hi @rajesh.perusomula,

Welcome to UiPath Community!

Can you send me the sample file to test at my side…

Thank you
Balamurugan.S

15

I cannot attach any files here. Hence i sent you seperately. Please check & let me know

1 Like
16

Hi @rajesh.perusomula,

I didn’t get you files…

Thank you
Balamurugan.S