Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 25, 2014 at 07:56 PM

    Hi Shubham,

    Use the DataManagerRunPackageLink API.

    Shrikant

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 27, 2014 at 03:39 PM

    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


    package ID.jpg (136.6 kB)
    Add comment
    10|10000 characters needed characters exceeded