Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I print faster? | Excel Discussion (Misc queries) | |||
can this be done faster? | Excel Discussion (Misc queries) | |||
Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) | |||
faster than VBA macros | Excel Programming | |||
Which one is faster? | Excel Programming |