Is it possible to break Template pass???

[former_member182305]

Hello experts,

I wonder if there is a way to break a template password that was blocke using BPC funcionality, not excel pass.

I am on BPC 10.1 Classic Version, CPMBPC 810 SP 0009.

Thanks for the post.

P.S. I tried to use VBA but didn't work, since the pass is BPC not excel.

Regards

[former_member186338 · Accepted solution]

I have found the location of the Workbook EPM password! It's in the hidden Workbook names with encoding.

I have updated my blog: https://blogs.sap.com/2016/12/01/how-to-get-epm-protection-password/

With the section:

Code to Get Workbook Protection Password

[former_member182305 · Accepted solution]

Thank you very much for the help Vadim.

How do you check the epm objects to know all this? 😮

Best Regards

[former_member186338 · Accepted solution]

Dirty hack 🙂

[former_member186338]

Please read my blog:

https://blogs.sap.com/2016/12/01/how-to-get-epm-protection-password/

[former_member186338]

P.S. The advantage of my blog is that you will not simply reset the password, but you will get it 🙂

[former_member182305]

Hello Vadim,

Thank you very much for your post. I am doing exactly what the post says.

1. Create an Excel file with the code you provided, the file called Unlock.xlsm

2. Copy - Pasted the code:

3. Activated the VBA Refeferences:

4. But the generated file code is as I hadn't password in the template:

Am I doing something wrong??

Regards.

[former_member182305]

P.S.

I am guessing that it is because I locked the complet workbook :S

[former_member186338]

But you are checking not BPC locked template 🙂 "false"!

[former_member186338]

P.S. My code will get a password only from BPC locked template!

And the correct protected sheet has to be active when you run the macro! Ensure that protected report is the selected tab!

[former_member186338]

"I am guessing that it is because I locked the complet workbook :S"

If lock a complete workbook using BPC locking - then all sheets containing reports will be locked with the same password... I will test the same!

[former_member186338]

Yes, for workbook lock it's not working, the password is stored in some other object!

I will check!

[former_member182305]

Hello to everyone reading this post. I found the answer in this link:

https://archive.sap.com/discussions/thread/3950421

Thank you very much andresmauricio.morenogarzon.

Regards.

[former_member186338]

Please, don't send your file to external site, use other methods described in the same question!