I recommend to use universal code (standalone EPM or EPM in AO) from the note: https://launchpad.support.sap.com/#/notes/2451876
Public Sub RefreshSheet() Dim API As Object Dim epmCOm As Object On Error Resume Next Set API = Application.COMAddIns("FPMXLClient.Connect").Object If Err.Number <> 0 Then Set epmCOm = Application.COMAddIns("SapExcelAddIn").Object Set API = epmCOm.GetPlugin("com.sap.epm.FPMXLClient") End If API.RefreshActiveSheet On Error GoTo 0 End Sub
Sorry, but where did you found this code? Have read EPM help????
Add comment