Skip to Content
0
Former Member
Jul 11, 2016 at 05:35 PM

Power Designer 16.5.5 Import Model from Excel issue

180 Views

SAP Power Designer 16.5 SP05 PL02 (64-bit) Version 16.5.5.2 (4734) I am trying to import a model using Excel. I am getting the following error: "Object creation can only be done through composition collections (0x80020009) at line 4722, character 4". After I select ok I am prompted if I want to fix the script. I select yes, then the Extension Properties Dialogue box opens with the Method Script tab selected. Below is the script contained within. I never get prompted by the Wizard to select the excel file to use for model creation. Any help on this is greatly appreciated.

Sub %Method%(obj)

' Create new object Dim import

set import = obj.ExtendedObjects.CreateNew()

if not import is nothing then

import.Stereotype = "ExcelImport"

' Launch import

import.ExecuteCustomMethod "%CurrentTargetCode%.Import"

' Detect error

If import.GetExtendedAttribute( "%CurrentTargetCode%.DataSourcePersist") = "" then

import.Delete

End If set import = nothing

End If

End Sub