VBA execution speed

[jungix]

Hi,

I just wondered how fast VBA was. If some of you tried to program the same thing in VBA and other languages, could you tell us how you would compare the speeds. Is is slower than C++ and how much? Is it faster than java?

[Zack Barresse]

Hi there,

Probably on the slowest end of the slow programming language (execution) speeds. There are a lot of articles on topics like this on the internet. This is mainly because of how they are constructed and how they compile the code. Here is an interesting article..

http://mail.python.org/pipermail/pyt...er/248373.html
http://mail.python.org/pipermail/pyt...er/248297.html

.. and here as well ..

http://theopensourcery.com/vbjava2.htm
ttp://tinyurl.com/mn2gq

.. and my personal favorite ..

http://www.codematic.net/excel-user-...-functions.htm

HTH

[Killian]

Is is slower than C++ and how much? Is it faster than java?

Depends what you're doing and how you implement it.