VBA : Trigger DMP present in another model

[arun_varghese]

Hi All,

System: BPC 10 NW

I am having an Excel template in CONSOLIDATION model.

I want to trigger an Exchange Rate Load package present in RATES model, using a Button/Macro combo.

How can we achieve this in VBA wherein we have option to pass connection string of another model to trigger the package?

[former_member186338]

You can use SetActiveDataManagerConnection(string connectionString) to temporary change DM connection to Rates Model, run package in Rates and change connection back to Consolidation.

Please read also my blog: https://blogs.sap.com/2017/06/16/simple-vba-function-to-pass-parameters-to-dm-packages/

[former_member186338]

Do you need to pass any parameters? Prompts?

[former_member186338]

And silence...

[arun_varghese]

Yes...looking to trigger silently with parameters being passed in Macro code

Infact, currently I am able to trigger packages of the same Model by creating local XMLResponseFile with params via Macro and then using it to trigger package silently.

Now, I need to find an option to trigger a package contained in RATES model, from a template contained in CONSOLIDATION model.