Handling edit Protected excels

Help
1

Hi,

I have a bot that works on an excel downloaded from a website. When the downloaded file is opened, excel shows that it is in protected mode, and we have the “Enable Editing” button at the top. I can use the click activity to click it, but that is not full proof, as it uses the Active Window activity to perform, and the selector for the Active Window can change for a different file.

image
image890×73 3.59 KB

Is there another way to tackle this?. There’s an option under Tools > Options > Trust Center > trust Center Settings > File Block Settings. I can also choose to modify the setting here, but would like that to be the last resort

image

Please advise
Regards
Aman

2

This may help:

However if you are using Uipath Excel/workbook activities, are you facing any challenge?

3

Hi @Sourav_Anand

I am getting the below error as soon as it opens the file

image

Regards
Aman

4

try by changing the protected view settings as described.
You can use do not open selected file types.
once the download is done directly use a ecel application scope to read the excel.