Refresh EPM worksheet by default when open workbook BPC 10. 0 NW

[Former Member]

Hi Guys,

we are using BPC 10.0 NW How to refresh one specific worksheet by default in EPM workbook has multiple worksheet. Is there any Macros or any specific settings we can do to refresh only specific report by default when open EPM work book.

I would appreciate if some one  helps me on this.

Thanks in advance.

Thanks

SG

[former_member186338 · Accepted solution]

Hi,

Please read help: 42.7 Custom VBA Functions (Events)

Create new module and put the function

Dim epm As New FPMXLClient.EPMAddInAutomation

Function AFTER_WORKBOOK_OPEN()

   ThisWorkbook.Worksheets("NameOfSpecificWorksheet").Activate

   epm.RefreshActiveSheet

End Function

Vadim

[former_member186338 · Accepted solution]

P.S. You can even refresh some specific report on the specific sheet if:

Dim epm As New FPMXLClient.EPMAddInAutomation

Function AFTER_WORKBOOK_OPEN()

   ThisWorkbook.Worksheets("NameOfSpecificWorksheet").Activate

   ThisWorkbook.Worksheets("NameOfSpecificWorksheet").Range("B15").Select

   ' B15 - cell of the specific report

   epm.RefreshActiveReport

End Function

[Former Member · Accepted solution]

Thx Vadim. It is working

[Former Member]

This message was moderated.