Macros Written in Excel 2000
 

I have a number of extensive Exel workbooks that have a lot of macros in
them. They were written using Excel from Office 2000 and we have recently
upgraded to Office 2003.

Some applications have macros now that are taking up to 2 hours to run where
they used to run in about 10-15 mintues.

Is there an way to convert these macros to the newer version so they run
more quickly?

Any help would be greatly appreciated.

Atley

Macros Written in Excel 2000
 

No. No conversion should be necessary. You will have to roll up your
sleeves and find what is causing the increase in run time.

--
Regards,
Tom Ogilvy


"Atley" wrote in message
...
I have a number of extensive Exel workbooks that have a lot of macros in
them. They were written using Excel from Office 2000 and we have
recently
upgraded to Office 2003.

Some applications have macros now that are taking up to 2 hours to run
where
they used to run in about 10-15 mintues.

Is there an way to convert these macros to the newer version so they run
more quickly?

Any help would be greatly appreciated.

Atley

Macros Written in Excel 2000
 

As a guess I would be inclined to look for areas where you making changes in
a loop and the spreadsheet is being re-calculated. 2003 does handle
calculation ever so slightly different from 2000 (calculation engine was
re-wrintten for 2002). Here is a link to a sight that will give you some
indications of the changes in calculations. It should just be a matter of
toggling the application.calculation setting.

http://www.decisionmodels.com/calcsecrets.htm

Like I said though that is just a guess. This kind of thing is tought to
debug because when running code line by line you do not notice the calcs
running...
--
HTH...

Jim Thomlinson


"Atley" wrote:

I have a number of extensive Exel workbooks that have a lot of macros in
them. They were written using Excel from Office 2000 and we have recently
upgraded to Office 2003.

Some applications have macros now that are taking up to 2 hours to run where
they used to run in about 10-15 mintues.

Is there an way to convert these macros to the newer version so they run
more quickly?

Any help would be greatly appreciated.

Atley