ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   faster than VBA macros (https://www.excelbanter.com/excel-programming/305171-faster-than-vba-macros.html)

K Dales

faster than VBA macros
 
Any "pure" programming environment will be more efficient
than VBA, but I don't think it would speed things by the
order of magnitude you describe. I suspect you may need
to optimize your code better. The way you implement your
algorithm - especially any sorting/searching/looping, can
make a big difference in speed of execution. To me that
is the most likely explanation for such a vast difference
in speed of execution.

-----Original Message-----
I use a lot of VBA macros in excel (2003). One of them

runs 50,000 Monte Carlo simulations and it takes 3-4 hours
to run on a 3 gigaHz machine. I've seen demos where
100,000 scenarios run in less than 1 minute. I think I
need to learn a faster language to implement my macros.
Any recommendations? C++, C#, something else?
--
GP
.



All times are GMT +1. The time now is 08:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com