I am trying to read and edit a xlsm file by using an excel application scope, but it is not working.
The file is by default in “read only” mode. The option is unchecked in Studio.
There is no error, but a popup appears asking if I want to read only or modify. The robot is supposed to be unattended so we can’t afford having this kind of problem.
Another problem, the filters are still activated, but the option UseFilter is unchecked. I don’t want to use the filters that are active on the sheet.
Please note that I can’t provide the xlsm files
Studio Enterprise 2020.4.3
Excel package: 2.8.6