Is there a way of opening password protected Word and Excel files without manually entering password when developing an application or document level VSTO Add-in. In other words, how do I set the password programmatically.
I have tried to do it in the document open event but it is invoked after opening document.
Is there an event which is invoked before the document gets opened?
Basically what I want to achieve is avoid opening the document outside the my Add in
Open
method. It's not clear that an application-level add-in would "know" the password for every document that could be opened? And anyway, hard-coding passwords isn't particularly secure... – Cindy Meister