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

I would go for a class module approach, storing each new instance
of the class in a Collection object.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Trip" wrote in message
oups.com...
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

Thank you Chip!

Can you point me to any good examples of this being done? This would
be a great help since I'm somewhat of a class/ood newbie.

Thanks again!

Trip

set up a class wrapping a variant collection or better thre
collections
as your input class

create a parent class with a variant collection to add inputs in

--
Dnere

-----------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...fo&userid=2618
View this thread: http://www.excelforum.com/showthread.php?threadid=46627