Macro's execution time

[michlimes]

Hello All,

Is it possible that macro is faster on Excel 2003 then on Excel 2007?

Do you know why i Can optimize macro to Excel2007? Which command may slow down my macro?

 

[schielrn]

We'd have to see your code to know which command might be slowing it down?

 

[RoryA]

It is definitely possible - see for example this report.

 

[michlimes]

My macro is very long, and connect to SQL using adodb...

Macro very often manipulate with cells values - i have read that this operations are slower than in excel2003.

How can I resolve this? Is application.screenupdating help with this?

 

[RoryA]

Yes, use:

Application.ScreenUpdating = False

at the start of the routine and reset it to True at the end. Your code will probably still be slower in 2007 but it should speed both versions up. You should also review your code to try and make it as efficient as possible - avoid selecting things, try to avoid writing to one cell at a time if you can write to lots at once and so on.