'Open Information Rights Management Protected File with vba macro in excel
My macro cannot open the excel file from a path, because it is protected (Information Rights Management). I can't disable it in the trust center settings, Application.DisplayAlerts = False does not solve the issue neither.
When opening the file, a message pops up which I need to click OK to open it, but no line of code I came across could do this task for me, I always get "Method 'Open' of object 'Workbooks' failed.
I am using Workbooks.Open(...). The macro would work perfectly fine, if it could bypass the pop up.
Many thanks in advance for any advice.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|