VBA Equivalent to List<T> in C# [duplicate]

Question

Possible Duplicate:
VB6 equivalent to a List<T>

Duplicate of:

Access VBA equivalent to a List<T>

I posted this question with the wrong information before, so I am reposting it in the hopes of getting a correct answer. 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?

Next time you post a question with wrong information, please edit the question to fix it. Thanks! — Timwi
– Timwi, Commented Aug 18, 2010 at 21:36

Dan Tao · Accepted Answer · 2010-08-18 20:24:28Z

0

Firstly, COM has no concept of generics; so you won't have any luck trying to make something out of a List<string[]>.

Why don't you just add an overload to your C# method to accept a string[][] (a jagged array of strings)? That should be doable from VBA, unless I'm mistaken.

I apologize if this answer is way off the mark; I don't have MS Office installed on this machine and am basically answering based on my limited knowledge of VBA and COM interop. But I thought the jagged array suggestion might at least nudge you in the right direction.

answered Aug 18, 2010 at 20:24

Dan Tao

129k57 gold badges309 silver badges451 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Icemanind Over a year ago

I don't think VB6 has jagged arrays. I think you mean Multidimensional arrays, which VB6 does have

Lance Roberts Over a year ago

@icemanind, VB has jagged arrays (type variant).

Collectives™ on Stack Overflow

VBA Equivalent to List<T> in C# [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related