Macro using API for refresh selected data

[Former Member]

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

[Former Member]

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!

[Former Member]

Also, don't forget to save the report (or any report with macros) as *.xlsm type!  Otherwise you will lose the macro.

[former_member186338]

Hi DiAn,

I don't understand the idea to repeat the previous answers! Just for points???

Vadim

P.S. No points for this discussion 🙂

[Former Member]

I disagree.  I provided a clear direct solution. As Andries nicely pointed out "We are here to try and assist after all".  This is why I participate here at SCN.  Points are only good for coffee and frequent flyer miles!

[former_member186338]

Bad idea!

If the question is already answered like in this case there is no reason to provide absolutely obvious additional explanation. A lot of people here like to repeat the same answer with some extra words... Even before comments from the topic author.

Vadim

[Former Member]

My final remarks here..."already answered" and "absolutely obvious" are just your perceptions not necessarily the posters position.  What is important is helping others with their issues and doing so WITHOUT bashing other helpers.  Please consider your tone in your 2nd post here.

[former_member186338]

Yes, my perceptions!

I will always fight with not relevant or repeated answers. It's against the forum rules.

If I am not right I will always post about my mistakes.

Vadim

[Former Member]

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

[Former Member]

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

[former_member186338]

Sorry Andries,

Please don't post not relevant information! Your link has no relation to the discussion question!

Vadim

[Former Member]

Vadim,

The FPMXLClient would be the likely place to find all of the Macro functions available , so it does have relevance. I was merely pointing Edouard to the area where he can start looking for a suitable function or working on a workaround.

We are here to try and assist after all.

Regards,

A

[former_member186338]

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

[former_member186338]

There is no api function like you want...

Vadim

[Former Member]

ok, thanks Vadim