Skip to Content

Using VBA to Bypass EPM Logon Upon Opening Excel

Feb 07, 2017 at 09:26 PM


avatar image


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!!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin 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.

Show 7 Share
10 |10000 characters needed characters left characters exceeded

P.S. Help: Connect


Hey Vadim....have you tested it? I am not able to get it to work....


Yes, it works without issues:

Dim epm As New FPMXLClient.EPMAddInAutomation
strConn = "_FPM_BPCNW10_[http://" & strServer & "]_[" & strEnvironment & _
            "]_[" & strModel & "]"
epm.Connect strConn, strUser, strPassword<br>


strServer - server URL like

strEnvironment - environment name

strModel - model name

strUser - user name

strPassword - password


Thanks Vadim...But I was looking for the API version. Trying to execute it through EPMExecuteAPI......Connect. The connectionstring parameter is not working!


Sorry, but Connect function is not designed to be used with EPMExecuteAPI. Clearly stated in help!


My Bad! So I understood it wrong.....please correct me. so the API suggested in help from section Connect and all others are to be used in macros and not in EPMExecuteAPI function????

Show more comments