S
Subodh
I have some data that are calculated once in an array.
Now, as the calculations are very time consuming, so i won't like to
perform the calculations again.
So, for the first time the workbook is opened, it should do the
calculations and then proceed with other
operations in the code that uses the numbers inserted in the array.
And, for the next time onwards, it should not do the calculations (as
i want to have the numbers already in an array), it should only do the
operations after the calculations.
This saves time significantly as the time consuming calculations are
not performed each time.
But, as i distribute the workbook to many users on different
computers, it should first check the computer if the values are there
in registry
and if not it should do the calculation else retrive data from the
registry.
T0 large numbers of data, lets say 10000 into registry is also a
problem, i felt
Further, I wonder if there is any alternative way to solve the
problem.
Any tips in this regard will be appreciated.
Now, as the calculations are very time consuming, so i won't like to
perform the calculations again.
So, for the first time the workbook is opened, it should do the
calculations and then proceed with other
operations in the code that uses the numbers inserted in the array.
And, for the next time onwards, it should not do the calculations (as
i want to have the numbers already in an array), it should only do the
operations after the calculations.
This saves time significantly as the time consuming calculations are
not performed each time.
But, as i distribute the workbook to many users on different
computers, it should first check the computer if the values are there
in registry
and if not it should do the calculation else retrive data from the
registry.
T0 large numbers of data, lets say 10000 into registry is also a
problem, i felt
Further, I wonder if there is any alternative way to solve the
problem.
Any tips in this regard will be appreciated.