We are upgrading from Office 2000 to 2003. We have created spreadsheets and
forms with very complex macros and would like to know if the macros will be
perserved in the upgrade process or if they will be wiped out.

Annette wrote:
We are upgrading from Office 2000 to 2003. We have created spreadsheets and
forms with very complex macros and would like to know if the macros will be
perserved in the upgrade process or if they will be wiped out.


I have experienced problems in the past but only had to make minor
changes in the code to overcome it.

they should be preserved. And they should work. There should be very little
incompatibility between xl2000 moving to xl2003 (if any). Both use VBA6.

--
Regards,
Tom Ogilvy


"Annette" wrote:

We are upgrading from Office 2000 to 2003. We have created spreadsheets and
forms with very complex macros and would like to know if the macros will be
perserved in the upgrade process or if they will be wiped out.

The only issue that I know of specifically is with code for pivot tables. The
Pivot Table engine changed in 2002 and the code along with it. If you are
coding against pivots then you will have to do so re-writing. Otherwise there
will be very few (if any) issues... Issues will consist usually with things
like alerts poping up or such in 2003 that were not present in 2000.
--
HTH...

Jim Thomlinson


"Annette" wrote:

We are upgrading from Office 2000 to 2003. We have created spreadsheets and
forms with very complex macros and would like to know if the macros will be
perserved in the upgrade process or if they will be wiped out.