Skip to Content

How to EPM password

sheetpwd.png

Hello Team,

Using below thread i tried to get the EPM password but it is showing blank in the result for <SheetPWD>.

https://blogs.sap.com/2016/12/01/how-to-get-epm-protection-password/comment-page-1/#comment-404571

Attached screenshot for reference.

Please do the needful.

Thanks

Prasad

sheetpwd.png (3.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 03 at 08:38 AM

    Sorry forgot to mention error message

    "Object not found"

    Add comment
    10|10000 characters needed characters exceeded

    • The idea of finding workbook password is simple: it's stored in the Excel name object with the name containing

      EPMWorkbookOptions

      check in debug - do you have this name?

  • Jan 03 at 07:37 AM

    Try code to Get Workbook Protection Password!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03 at 08:28 AM

    Hi Vadim,

    Yes i tried workbook code also but it is getting into error...this particular statement it is showing error...

    bytArr = objNode.nodeTypedValue

    But, for other reports\templates this workbook code is working fine.

    Is there anything which i need to change in the logic. For worksheet logic, i am not getting any error but when i check the result it is showing as blank.

    Thanks

    Prasad

    Add comment
    10|10000 characters needed characters exceeded