Create class module that when instantiated creates a tab from an array of db values?

Right now, I have a vba application that draws a tab based on a series of values that are already in memory. It works just fine, however, the act of creating the tabs from the aforementioned MDX queries is not as fast as I think it could be if it were a class object .

Is there an effective manner to create a class module that creates a worksheet when instantiated and assigns values/formulas ? How does this work? It seems like it should be faster.. but that is why I am asking.

If it is, how do I approach this?

I have experience in c++/java from way back in object orientated programming but I am rusty.

Right now the tab creation and drawing process takes about 2 seconds per tab and is 76R by 29C. I would like to cut that in half or less.

To recap, the goal is to do the following:

1. Associate and apply values from a 3 dimensional array to a class object
2. Class object instantiation results in creation of new, named workbook tab
3. Do it fast

Thanks

Also, I have searched extensively and I am just not finding anything from which I can build.

That is actually what I started with as far as all of the labels. The values are actually dynamically queried via MDX so they have to be written at some point.

Thanks for the input.


Here is what I ended up doing today.....


1. Write a hard coded array of the side/top labels since these never change
2. Created a class file object for just the individual reporting unit
3. Indexed the reporting units by hierarchy in a collection
4. Store an entire 4d array across 24m of data into 1 variant array in the class file
5. Have Collection in memory at runtime based on user input ready to write object values

It is WAY faster than before. The act of iteratively computing then writing values on a per reporting unit subset of the collection was insanely slow versus this.

For i, for j, for z, for l.... write value from a preindexed, dimensional flat file vs just 2 nested loops of preloaded, preindexed values from a class object

Yeah. Pretty obvious in hindsight I suppose.