I have a large application in VB 6 that uses collections to handle passing data from an input program to an activex dll. For example the collection contains 4 different Propertys defined as doubles or singles.
When I intialize the class I automatcily add 120 items so that the user can pass their data from an array or grid to the dll. IE:
The user addresses the collection as follows
input.outlays(x).Loans = 1500.00
input.outlays(x).Withdrawls = 200.00
The problem is the large time and overhead it takes to create the collection with 120 items at the Class initalization. What I want to do is convert this to use a UDT of arrays ie:
Loan as Double
Withdrawl as Single
Public myVar as Outlays(120)
I would like for the user to be able to use the same syntax as above to set the values if possible and if not possible how would you accomplish this.