Macros running much slower in 2007/Win7

**surfengine** · 03-29-2010, 11:43 AM

Anybody else experience this? My macros all run much slower. Some of them went from 10minutes to 2hours. Others just 5s to 10s, or so.

Is there some kind of setting somewhere to speed it up?

I upgraded to office 2007 and win7 at the same time, so i dont know if it is related to 2007 or win7, or both.

**romperstomper** · 03-29-2010, 11:54 AM

VBA in Office 2007 is generally slower than in previous versions, especially with charts/drawing objects, but it shouldn't be that much slower as a rule. We'd need to see an example to be more specific, I think.

**surfengine** · 03-29-2010, 01:40 PM

Generally most of the marcros I run will have an end result of a chart or multiple charts. Even hundreds of charts (as in the case of the 2+hour macro).

I was wondering if there wasnt some type of 'run macro in background' option or code that would make it run faster.

**romperstomper** · 03-29-2010, 05:51 PM

Unfortunately not. (there's no Application.DoStuffFaster property) The entire charting object model was changed in 2007 and let's just say it's not exactly perfect (witness the fact that the macro recorder barely works with charts in 2007). The best you can do really is throw as much power at it as possible, use Multi-threaded calculation if you can (though it won't help on the pure VBA side) and optimise your code as far as humanly possibly - that part is much more important than it used to be.