I just got my Office 2007 and tried to run my Macros developed under Excel
2003. Then I found it runs very very slow. I campared many of my macro and
found all of them run much slower than in Excel 2003. Is there anything
wrong? Or anything I can do to improve it?
Thanks.
--
VBA

Hi, in my opinion, you should set references to all the add-ins your macros
refer to. Also, you should check your computer's RAM and operating system, if
it is capable of handling advanced software such as Office 2007.

"Bin" wrote:

I just got my Office 2007 and tried to run my Macros developed under Excel
2003. Then I found it runs very very slow. I campared many of my macro and
found all of them run much slower than in Excel 2003. Is there anything
wrong? Or anything I can do to improve it?
Thanks.
--
VBA

My Macro does not include any Add-ins. Also, my computer has big enough RAM
to handle Office 2007. After try agin and again, I found there are many
differences to handle Chart between Office 2007 and Office 2003. Such as
Shape property and many many others. I have to modify my Macro to fit Office
2007 if I want to use it. In my experence, a Macro that working on many
Charts developed under Office 2003, if working in Office 2003, it may take 2
minutes. Working in Office 2007, take 2 more hours. After modified to fit
Office 2007, now take about 3 minutes. Conclusion: Use macro developed under
Office 2003 in Office 2007 may slow down a lot. You have to modify it to fit
Office 2007 if you have to use Office 2007. It is offset.
I heard many people has same nightmare in my company.

--
VBA


"Madhan" wrote:

Hi, in my opinion, you should set references to all the add-ins your macros
refer to. Also, you should check your computer's RAM and operating system, if
it is capable of handling advanced software such as Office 2007.

"Bin" wrote:

I just got my Office 2007 and tried to run my Macros developed under Excel
2003. Then I found it runs very very slow. I campared many of my macro and
found all of them run much slower than in Excel 2003. Is there anything
wrong? Or anything I can do to improve it?
Thanks.
--
VBA