ExcelBanter

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

Tom Ogilvy

faster than VBA macros
 
It may be how you have written your macro - how you are interfacing with
Excel - how you are recording your results.

But yes, a compiled language such as C++ should be faster than an
interpreted language in most cases.

--
Regards,
Tom Ogilvy

"Rimcon" wrote in 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 05:33 AM.

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