View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Barb is offline
external usenet poster
 
Posts: 70
Default VB6 faster than VBA in Excel?

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