Skip to Content
author's profile photo Former Member
Former Member

Macro using API for refresh selected data

Hello,

I'm trying to do a macro using the EPM function refresh selected data but i don't find the API in EPM add-in user guide.

Does anyone knows if this function exists ?

Thanks in advance,

Edouard

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Mar 10, 2016 at 10:56 AM

    There is no api function like you want...

    Vadim

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 10, 2016 at 01:40 PM

    Hi,

    Is this not what you are looking for? http://scn.sap.com/people/devon.abraham2/blog/2012/02/23/using-the-api-in-epm-100-nw-bpc

    Regards,
    Andries

    Add a comment
    10|10000 characters needed characters exceeded

    • Andries,

      In general everything is related to everything 😊

      And FPMXLClient.EPMAddInAutomation is the place where all functions can be found - documented in the API guide and not documented.

      And I can see undocumented Sub RefreshSelectedCells() here. If you have pointed to this function instead of some general link - then you answer has been relevant.

      Vadim

  • author's profile photo Former Member
    Former Member
    Posted on Mar 10, 2016 at 05:55 PM

    Here is the VBA code you need for this API. You will need to activate FPMXLClient in Tools--> References first, then link the macro to a button on the report:

    Dim EPM As New FPMXLClient.EPMAddInAutomation

    Sub Refresh_Selection()

    Dim EPM As Object

    Set EPM = Application.COMAddIns("FPMXLClient.Connect").Object

    EPM.RefreshSelectedCells

    End Sub

    Good luck!

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin

      Vadim,

      It is my opinion that you might want to reconsider your stance regarding this situation. We do not get paid to try and resolve people's issues, we do it because we have also struggled getting issues resolved and any direction is usually helpful when you are stuck. When you go about bashing people when they try to help it will discourage posting whatsoever.

      Regards,
      Andries

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.