Question Re: VBA Run Automation in Data Manager Package in Financial Management Q&A

VBA Run Automation in Data Manager Package

Former Member — Thu, 30 Jun 2016 09:53:52 GMT

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 — Thu, 30 Jun 2016 12:31:52 GMT

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 — Thu, 30 Jun 2016 12:44:52 GMT

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 — Fri, 01 Jul 2016 01:40:50 GMT

Thanks Vadim

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