on 11-02-2021 7:23 AM
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"
epm.RefreshActiveWorkBook
Application.ActiveWorkbook.Save
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
https://blogs.sap.com/2015/09/04/how-to-guide-dynamically-enable-fpmxlclient-reference/ but I do not understand how to add this to the above code.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.