Run package from Excel Button

[Former Member]

Hello experts:

I am working on the definition of some input schedules and I would need to run package from some buttons. I have found the command "MNU_DATA_RUNPACKAGE" but It opens the data manager but I need to run the package directly.

I am running from an excel button "refresh", "sending of data", etc... But, How can I find the command to execute and specific package? I would like to run the copy function, the distribution function, weihgt, trend, etc...

Thanks in advance for your help

Kind regards

Jose

[Former Member · Accepted solution]

Hi Jose,

Assign a macro to a button. Give some name to the macro. Lets say MyMacro.

Then edit the code of the macro:

Sub MyMacro()
Application.Run "MNU_eDATA_SELECTPACKAGE", "Allocate Budget", "My Files/Allocate Budget.dtsx", "Company", "Data Management"
End Sub

Where,

Allocate Budget = DM Name

My Files/Allocate Budget.dtsx = Path of the DTSX file

Company = Folder in which the DM has been saved

Data Management = Folder in which the DM has been saved

Hope this helps.

[Former Member · Accepted solution]

Thanks Nailanjan.

But are there any direct macro created for the functions spread, weight, trend or to execute a package ( in the same way que there is an standard macro to send data)?

When I try to create the macro to run the "spread function", I can't stop the macro just after windows pop up and It is impossible to do exactly what I want to.

Kind regards

[Former Member · Accepted solution]

Hi Jose,

As far as my understanding says, there is no direct macro created for these.

[Former Member · Accepted solution]

Hi, Nilanjan

May I know where I can obtain the DM Package dtsx file  ?

BTW, I am working on BPC 7.5 NW SP9

Thanks so much

[Former Member · Accepted solution]

Hi Eddy,

Its stored in the server root folder. You can search for *.DTSX file on the server machine.

Hope this helps.