Downtime Announcement: Please note the SAP Community Wiki will be unavailable due to a system upgrade on Thursday, September 24th between 6 and 7 AM CEST
Page tree
Skip to end of metadata
Go to start of metadata
  • No labels

1 Comment

  1. Former Member

    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 with in. 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