Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I keep coming across situations where it would be really useful to
create collections within collections, but I just can't quite work it out. Here's the closest I've gotten: I have a class module called Sample, with the following public variables (among others): Name as string SampleType as string Elements as collection in my main sub: dim Sample as Sample dim Samples as collection set Samples = new collection for each File in application.filesearch.foundfiles set Sample = new sample set Sample.Elements = new collection Sample.Name = (somevalue) for i = 1 to 10 Sample.Elements.add (somevalue, somekey & i) next i debug.print sample.elements(somekey) 'OK so far samples.add Sample '(with Sample.Name as key) Next File For each Sample in Samples debug.print Sample.Name 'Works debug.print sample.elements.count 'Works debug.print Sample.Elements(somekey1) 'Gives Error '424' Object Required debug.print Sample.elements(1) 'gives error also Next Sample Anyone out there know the proper way to nest collections or an elegant alternate? Thanks! -Lisa |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enumerations or Collections | Excel Programming | |||
For Each and Collections | Excel Programming | |||
Collections of Collections | Excel Programming | |||
Help with collections | Excel Programming | |||
Using Collections | Excel Programming |