Custom class collection

[bbeaucage]

I created a COM enabled class in VB.Net.

...
<ComVisible(True)>
<ClassInterface(ClassInterfaceType.None)>
<ProgId("Integration.PostInvoice")>
Public Class PostInvoice

Public Property InvoiceNumber As String
Public Property FileName As String
Public Property TransType As String
Public Property CustomerName As String
Public Property JournalDate As Date
Public Property ErrorMessage As String
Public Property DetailLines As New List(Of InvoiceDetail)
....

In Excel, I can create a new instance of the PostInvoice class, and I can see all of the properties, except for DetailLines.

The DetailLines property doesn't show, so I cannot .Add an item to that collection. In VB.Net, the DetailLines property is accessible.

Any suggestions would be greatly appreciated.

 

[bbeaucage]

I think I figured it out. List(Of ...) is not exposed through COM, so need to create a custom collection class with all of the proper members and methods.