Excel 2007 - Visual Basic - very slow

[JFF]

A Visual Basic procedure that I have used for quite awhile in my Office 2003, Excel, normally takes about 2 minutes to run.

Yesterday, I installed Microsoft Office Home & Student 2007 on the computer. To my amazement, the same procedure now takes 6 and a half minutes to run! No errors occur.

My computer is a Toshiba laptop that's one yr old, with 512 meg memory and 100 gig hard drive and and an Intel Celeron processor. It has Windows XP Professional on it.

I know that Office 2007 would like to run on a dual-core computer with 1 gig of memory, but why does it take 350% more time to run a VB procedure?

Any advice?

Thanks,
John

 

[SkipVought]

Hi,

How Can I Make My Code Run Faster? faq707-4105

Skip,
[sub]
[red][/red]
[/sub]

 

[JFF]

Skip,

Thanks for your help, but I already used many of the speed techniques in my VB code.

Why doesn't the VP in the Excel 2007 run the same code at least the same amount of time as the Office 2003 did? I wonder if anyone else experienced a slow down in their Visual Basic code execution when they switched "up" to Office 2007.

John