Hello all,

I have a quick VBA architectural question and any direction you may be
able to provide would be greatly appreciated.

I have created an Excel application which takes 3 real-time inputs (via
DDE), has roughly 60 variables of different types and about 12 outputs,
and about 2000 lines of code.

I now want to change the application so that it will handle multiple
sets of the 3 inputs simultaneously.

How would you suggest changing the architecture? Move everything into
a class and then instantiate an instance of the related object as
needed? Or, create a large array which can handle multiple instances
of each variable and loop through the array sequentially?

Any thoughts would be great!

Thanks,

Trip