Skip to Content
avatar image
Former Member

Using VBA to Bypass EPM Logon Upon Opening Excel

Greetings,

I've scoured the web for the answer to this question to no avail. I hope someone can help.

I use the EPM add in to pull data from BPC within excel. Is there a way to use VBA to automatically logon me into BPC? I currently have a SSO setup which allows me to bypass entering my credentials every time but I still have to click "Logon". I have tried creating macros but excel does not recognize when I click on the Logon button while recording the macro. Any assistance would be greatly appreciated. Thanks in advance!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 07, 2017 at 10:46 PM

    Please read EPM help API section. And get some training in VBA - macro recording is not the right way to automate EPM functions.

    Add comment
    10|10000 characters needed characters exceeded