can any one tell me how to remove hyperlink for any url which is stored in excel
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.
can you tell me how to do macro enable
Record your macro. Then click on Save As option, then select Save as Type as Excel Macro-Enabled Workbook
can you help me little bit more about what macro code should i have to write for this removing hyperlink
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
hi @PrankurJoshi what ever solution you have given to me is also applicable for making hyperlink to url as well ???
Ohh yes of course you can do that as well
can you give me any example of macro??? @PrankurJoshi
do u have any example file of macro ???so please can you share with me??
I have uploaded a custom activity to remove the hyperlinks from the excel sheet with selected range of cells.
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
Welcome to UiPath Community!
Can you send me the sample file to test at my side…
I cannot attach any files here. Hence i sent you seperately. Please check & let me know
I didn’t get you files…