Hi Charles,

Also in theory if you are doing very intense numeric calculations (for
example iteratively solving partial differential equations) then compiled
VB6 will be somewhat faster than VBA.

I think for some things like that, or for manipulating large amounts of data
using memory swaps, VB6 can be very significantly faster than VBA when all
the compile options turned off (faster even C++ though that might be more
due to optimization). This is more a case of "I've seen it done" rather than
"I know how to do it" !

Regards,
Peter T



"Charles Williams" wrote in message
...
Joel,

So far I have found very few cases where compiled VB6 runs any faster than
VBA: usually 99% of the time is being used in either the VB runtime (which
is the same) or in transferring data between VB and Excel (which is the
same) or in operations in Excel itself (such as Calculation of formulae
etc).

The only significant case I know of is using Automation addins for large
numbers of UDF calls in Automatic calc mode, which bypasses the VBA IDE
refresh slowdown bug.
Also in theory if you are doing very intense numeric calculations (for
example iteratively solving partial differential equations) then compiled
VB6 will be somewhat faster than VBA.


Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Joel" wrote in message
...
Turn screen updating off and try again. You can get the V6 visual basic
compilerCompiler and compile the code to gain speed.

"BR" wrote:

My spreadsheet has grown too big, and VBA takes too long to run stress
tests
on it !

Can I use Excel for deal presentation purposes only, run the algorithms
faster in another language and interface that to Excel, please suggest
directions

(My company doesn't have an IT desk, apologies if this is too basic a
query)

--
-----