VBA Run Automation in Data Manager Package

[Former Member]

dear BPC Gurus

I've trying to write a VBA Code to execute the macro in Automation, in the "Run Package" dialog box.

Automation > Run automation.

Which I would like to execute this macro in ADMIN folder, in the MASTER DATA sub folder, a Macro file called "B_LEASE_ATTR.mrc"

I wrote this code:

Option Explicit

Dim EPMDMObj As New FPMXLClient.EPMAddInDMAutomation

Sub Run_DM_Macro()

    EPMDMObj.RunMacro "ADMIN\DATAMANAGER\TEAMMACROFILES\MASTER DATA\", "B_LEASE_ATTR.mrc"

EndSub

As shown in the library:

However, when I execute the code, it gave me error message:

Does anyone know what is wrong with my code?

This is the same question as but no one answered it, so I'm asking it again.

[former_member186338 · Accepted solution]

Sorry, but what are you trying to achieve using mrc automation? Useless feature to my mind...

You can fix answers directly in DM package advanced script

You can create a package link and set answer prompt

You can use vba to directly pass answers to DM:

[former_member186338 · Accepted solution]

P.S. The link provided in my previous answer is not working currently (link to pdf). To have an idea - read original idea hear:

[Former Member · Accepted solution]

Thanks Vadim

I thought the macro was quite a cool feature, lol...