Showing results for 
Search instead for 
Did you mean: 

How to activate EPM addin and FPMXLClient

Following Vadim Kalinin's guide (Log on to BPC/EPM using Excel VBA) I was able to create the below VBA that successfully logs on and refreshes my workbook. Note, for privacy I reverted some of the VBA back to the base version I learned from the above linked post.

Dim epm As New FPMXLClient.EPMAddInAutomation
Public Sub SignOn_Refreshworkbook()
strConn = "_FPM_BPCNW10_"_FPM_BPCMS10_[http://" & strServer & "]_[" & strEnvironment & _ "]_[" & strModel & "]"
epm.Connect strConn, "Username", "Password"
End Sub
My issue is that the machine I run this on does not always activate EPM/FPMXLClient. I attempted to follow the solution found here but I do not understand how to add this to the above code.
0 Kudos

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A , as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

Accepted Solutions (0)

Answers (0)