Access VBA equivalent to a C# List

Question

I have a COM-visible object written in C# that accepts a list of string arrays. Could I send a Collection of string arrays from Access 2000 to this object and it work? If not, then what is the best way to send multiple string arrays to my C# object from Access 2000?

Answer 1

You can't marshal generics but using Collection on the VB6 side is a workable solution. Effectively convert your List to a standard collection.

Here's something that elaborates more: http://www.codeproject.com/KB/COM/netclasslistvb6.aspx?display=Print

Answer 2

I do a lot of com add in work on VBA and vb.net - I find replacing a List (of T) in vb.net with an arraylist works very well in VBA, not all the properties expose exactly the same way in Access, but you can work around it.