Is there a way to use an array in VBA to permanently store data, so that the
data is intact the next time a workbook is opened? Specifically, here is
what I am trying to do:
I need to load production data in half-hour intervals over the course of a
week. So there are 336 bins per week, and a multitude of data to store into
the third dimension of the array for each bin. Then I need a complete record
of each week's production. Rather than have a massive workbook with 52
worksheets, 1 for each week, I would like to store all the data in a
permanent VBA array. When I want to show a particular week's data, I'll set
up some kind of pick list to extract the appropriate row/column data from the
array and load it into a designated range on a display worksheet. That way,
I only need a single worksheet instead of 52.
Basically, the array becomes a hidden database. Is there a way to do
such a thing?