In answer to your subject line - it depends on what the code does. As a
generalization one might expect VB6 to be a bit faster, though with certain
specific tasks and compile optimisations (n/a in vba) VB6 could be very very
significantly faster than VBA.

What's your definition of slow, importing and 'calculating' 100k records
will not be instantaneous.

From the little of what you have described I suspect/guess the main thing
that would speed up your process is to optimise your own code.

even if I did everything from the memory
with arrays before sending the result on a worksheet. is it the right
way?

Again guessing, doing just that would most probably help, perhaps
dramatically. Finally dump say 10k (of your 100k records) at a time to cells
rather than looping to individual cells, if indeed you need to touch cells
at all.

Why not post the steps you currently do, outline what you start with and the
overall objective.

Regards,
Peter T


"Barb" wrote in message
...
yes and it's slow! I don't know what to do!
Thanks.
"Tim Williams" wrote:

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