Question

A11 - How enable content at excel - Security Warning Message

  • 11 May 2023
  • 1 reply
  • 97 views
A
Badge

Hello Friends of AA11

I have a project that I download some SAP reports and make data modeling at Excel Power Query.

My bot is responsible for REFRESH the Excel Spreadsheet, but when my bot open the excel, excel shows to me a SECURITY WARNING because this table is reading data from another place.

I would like to insert a condition in order to identify that everytime that this message appears I’ll click on ENABLE CONTENT and CLICK OK at SECURITY NOTICE.

How is the better way to automatize this process ?

 

1 Attachment

1 reply

L
Badge +1

Hi Allan,

You can disable this kind of message on the security settings of Excel or you can make a step in your bot, before actual actions, to open the Excel as a program and deal with its windows to disable it, not using the Excel actions.

 

Reply


Terms & ConditionsCookie settings