P
pinkfloydfan
Hi all
On XL2003 I have written a function that builds 100,000 instances of
an object and stores them as a collection. Other functions then can
access this collection and perform further tasks.
Unfortunately this can take up a lot of memory, so in order to make
the best use of my memory I would like to be able to refer to a unique
identifier for the collection and first check if it exists. Then, if
it does exist I wish to set it to nothing before running the rest of
the function.
This is my first time using class modules. In the past I have always
used the type declaration to create objects and then stored them in an
element of a global, public array. In this way, if I then rebuilt
those objects I would end up just saving the data in the same element
and thus avoiding this memory problem.
Can anybody suggest the most efficient method to achieve my goal?
Many Thanks
pinkfloydan
On XL2003 I have written a function that builds 100,000 instances of
an object and stores them as a collection. Other functions then can
access this collection and perform further tasks.
Unfortunately this can take up a lot of memory, so in order to make
the best use of my memory I would like to be able to refer to a unique
identifier for the collection and first check if it exists. Then, if
it does exist I wish to set it to nothing before running the rest of
the function.
This is my first time using class modules. In the past I have always
used the type declaration to create objects and then stored them in an
element of a global, public array. In this way, if I then rebuilt
those objects I would end up just saving the data in the same element
and thus avoiding this memory problem.
Can anybody suggest the most efficient method to achieve my goal?
Many Thanks
pinkfloydan