Skip to Content
0
Aug 03, 2017 at 08:49 PM

"Automation error" when run VBA EPM RunPackage

291 Views Last edit Aug 03, 2017 at 08:52 PM 2 rev

Could someone help to fix my error in VBA.

I try to execute this code and got the error "automation error"....Thanks

=============================================

Sub test()

Dim pkge As New FPMXLClient.ADMPackage

Dim EPM As New FPMXLClient.EPMAddInDMAutomation

With pkge

.GroupId = "Data Management"

.TeamId = "BPC_CC"

.Filename = "/CPMB/CLEAR"

.PackageId = "Clear"

.PackageType = "Process Chain"

.PackageDesc = ""

.UserGroup = ""

End With

EPM.RunPackage pkge, "C:\Temp\DMUserSelection4.xml"

End Sub

===================================================

Here's my XML file

======

Clear{param_separator} http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd=" http://www.w3.org/2001/XMLSchema">

<_ap>

<Name>%SELECTION%</Name>

<Values />

</_ap>

<_apc>

<StringListPair> <str>CATEGORY</str> <lst> <string>ACTUAL_FMO</string> </lst> </StringListPair>

</_apc>

</AnswerPromptPersistingFormat>

</ArrayOfAnswerPromptPersistingFormat>