Disabling Protected View on Multiple Downloaded Spreadsheets

excel
uiautomation
activities

#1

Hi, part of a project I’m working on requires me to download an excel spreadsheet, but the sheet name changes day to day. As a result, when opened the spreadsheets are in protected view. I was wondering what the best way to automatically disable protected view when working with spreadsheets who’s names change every time they are downloaded?

Thanks for your time!


#2

Probably #1


#3

Thanks for the reply, but this is for someone who does not have the ability to have their trust center preferences disabled at all times, this is the problem I’m running into. Unfortunately, the protected mode message has to appear and be turned off.

Thank You!


#4

understood.

You can try ALT+FIE as your first step to disable, probably validate the exisitance by reading an image in protected view bar.

or

<ctrl name='Protected View' />
<ctrl name='Enable Editing' role='push button' />

check element exists “Enable Editing” before you start and click on it.


#5

I ended up using a series of click images to go through and inspect the workbook and remove all the conflicts.


#6

Hello guys,

I tried to use Send Hotkey Activity to send “Alt+t+p+p” to release a protected excel file but it does’t work. However Click Image Activity worked fine.

Does anyone know how to release a protected file using Send Hotkey Activity ?