Can you just do the calculations in the database?
Do you really need to return all of the records?

Tim


"Barb" wrote in message
...
Hi ,

My program is very slow even if I did everything from the memory
with arrays before sending the result on a worksheet. is it the right way?
I
created a button on Worksheet(0) and this button calls the Sub that will
gather 100000 Oracle records for doing calculation.


Do you know if it will be faster by creating a .exe from VB6? of all is
the
same when it's done from excel?

Thanks
J