![]() |
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