I want to run a package link using a macro code .

[former_member339201]

If there is a package RUN_CALC under package group COMPANY1 . Then I use the following macro code to run the package :

Dim EPM As New FPMXLClient.EPMAddInAutomation

Sub RUN()

EPM.DataManagerRunPackage "RUN_CALC", "COMPANY1", ""

End Sub

There is another set of calculations that is run through package RUN_CALC2 . Now I  have linked the two packages : RUN_CALC1 and RUN_CALC2.
Now I not getting any suitable macro code to run this package link . Please suggest the code .

Thanks,
SHUBHAM

[Former Member]

Hi Shubham,

1)     Create Package link.

2)     Set your prompts.

3)     Run  your package link using Data Manager-->Run Package-->Run Package link

To run package link through VBA you need unique name of package ID.

4)     After running package link go to SE16 select table name UJD_LINK_LOG.

5)     Then system will generate one entry in table UJD_LINK_LOG.

6)     Copy Unique ID of that package.

7)     Use that Package ID in the VBA Code.

Regards,

Sushant

[Shrikant_Jadhav]

Hi Shubham,

Use the DataManagerRunPackageLink API.

Shrikant