Creating an array of arrays of data objects?

Question

I have a data object

I also have arrays of these data objects

I want to put these arrays of data objects into another array

Dim ArrayOfDataObjects1(10) as new DataObject
Dim ArrayOfDataObjects2(10) as new DataObject
Dim ArrayOfDataObjects3(10) as new DataObject

'Now, I want to put all of these into another array, how can I?

Thanks!

edit: I know I need to create another array with size 3, but what type do I define the array as?

Wouldn't a collection do the job?

Oneide
– Oneide

2010-12-01 19:16:09 +00:00
Commented Dec 1, 2010 at 19:16 — Oneide
– Oneide, Commented Dec 1, 2010 at 19:16

Dr. belisarius · Accepted Answer · 2010-12-01 17:45:18Z

4

If you are not concerned with type-safety, you could use Variant. Example in Excel VBA:

Sub a()
Dim ArrayOfDataObjects1(10) As Worksheet
Dim ArrayOfDataObjects2(10) As Worksheet
Dim ArrayOfDataObjects3(10) As Worksheet

Dim arr(3) As Variant

Set ArrayOfDataObjects1(1) = ActiveSheet

arr(1) = ArrayOfDataObjects1

arr(2) = ArrayOfDataObjects2

arr(3) = ArrayOfDataObjects3

MsgBox arr(1)(1).Name

End Sub

edited Dec 1, 2010 at 17:45

answered Dec 1, 2010 at 16:48

Dr. belisarius

61.2k15 gold badges121 silver badges198 bronze badges

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

4 Comments

jtolle Over a year ago

I think using a Variant is the only way to do this, whether you're concerned with type safety or not.

Dr. belisarius Over a year ago

@jtolle I think you may create a Class Module to create objects to hold those values. But never did it, so ...

jtolle Over a year ago

Sure, I just meant that there is no VBA syntax to describe a strongly-typed array of array of dataobject...

Dr. belisarius Over a year ago

@jtolle Ahh OK. I misunderstood you.

Collectives™ on Stack Overflow

Creating an array of arrays of data objects?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related