Trigger a Logic script from macro code

[former_member339201]

Hi Experts,

I have a logic script that performs some allocation logic. I need to trigger the logic script by clicking on a button provided in an excel template.

How can I trigger the Logic script using macro code. Precisely I need the code(if it is possible) so that we can trigger the desired logic script.

Regards,
SHUBHAM

[former_member186338 · Accepted solution]

If you need to pass some parameters to DM package with script logic then the only solution is

[Former Member]

Hi Shubham,

You can trigger that script logic, by calling it through a Data manger package /CPMB/DEFAULT_FORMULAS. Add your script name in this process chain by going to the "Advanced Script". Create a button and assign this macro to run the data manager package..

Option Explicit

Dim EPM As New FPMXLClient.EPMAddInAutomation

Sub (Button Name)

EPM.DataManagerRunPackage "(Package name)", "(Group ID)", ""

End Sub

Regards,

JP

[former_member186338]

For allocation you will need to pass some parameters to the logic script (99% probability). Then - the link in my previous message!

[Former Member]

Yes...precisely! But the author needs to mention that. many people fail to give all the requirements in a go...its really confusing sometimes as to what they really require....sometimes its just basic things.

[former_member186338]

You have to think what is behind the author's question