How to enter a KNOWN password for an addin from another addin

[crewaustin66]

Let me be clear that I know the password and can enter it when I click the project and get in fine. I just need to be able to do this from VBA code. Here's why.

I'm using VBE to write the addin's source code to a flat file for use in a source comparison app. You can't read the project code, change the project name, or anything if the addin protected. Manually unlocking it and running my code (kicked off from a ribbon bar button) does work. I've seen folks' attempts at this with SendKeys (ugh!) and smarter ones with windows api calls and SendMessage but it doesn't appear to work in newer versions of Excel (2013, at least, on up).

Does anyone have a solution to this?

Thanks,
-Crew

 

[crewaustin66]

Ok now this is the bomb! It works REALLY well. I was just about to write a password ******* but you saved me from that task. Thank you VERY much JaaFar!!

 

[Jaafar Tribak]

I am glad it worked for you .. Thanks for the feedback.