Skip to Content
avatar image
Thandeka Masiya

VBA code to refresh active sheet

Feb 21, 2018 at 02:19 PM | 248 Views | Last edit Feb 22, 2018 at 05:25 AM 5 rev.

Hi

I have an issue with BPC 10.1 standard, EPM Add-in. I am trying to write a VB code to refresh the data when I click on the worksheet. I have this code below but it can be unreliable. Any suggestions?

Sub Report4()
Sheets("Report4").Select
Application.Run "EPMExecuteAPI", "RefreshActiveSheet"
End Sub

Thanks in advance

EPM Add-In for Excel
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Vadim Kalinin
    Feb 21, 2018 at 03:45 PM

    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
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Vadim Kalinin
    Feb 21, 2018 at 03:39 PM

    Sorry, but where did you found this code? Have read EPM help????

    Add comment
    10|10000 characters needed characters exceeded