ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Migration from Excel 2000 to 2003 (https://www.excelbanter.com/excel-programming/346505-migration-excel-2000-2003-a.html)

Rene H

Migration from Excel 2000 to 2003
 
Hi,

What are the changes I have to deal with when I upgrade from Excel 2000 to
2003?
Will my Excel 2000 sheet, with macros and VBA, work without any problems in
2003? Is there any information from Microsoft what has to be changed in
macros or VBA code?
Any helpy appreciated.

Cheers
René

Gary''s Student

Migration from Excel 2000 to 2003
 
Most of the changes should not be visible. You may have to re-enter some of
you custom settups, like which menu bars are open for use, etc.
--
Gary's Student


"Rene H" wrote:

Hi,

What are the changes I have to deal with when I upgrade from Excel 2000 to
2003?
Will my Excel 2000 sheet, with macros and VBA, work without any problems in
2003? Is there any information from Microsoft what has to be changed in
macros or VBA code?
Any helpy appreciated.

Cheers
René


JNW

Migration from Excel 2000 to 2003
 
Most of the problems with migration occur when you go backwards to an older
version. Microsoft attempts to accomodate code from past versions (back to
97 I believe). But, as they include new functionality in the newer versions,
things you do with 2003 might not work with older versions.

"Rene H" wrote:

Hi,

What are the changes I have to deal with when I upgrade from Excel 2000 to
2003?
Will my Excel 2000 sheet, with macros and VBA, work without any problems in
2003? Is there any information from Microsoft what has to be changed in
macros or VBA code?
Any helpy appreciated.

Cheers
René


Nick Hebb

Migration from Excel 2000 to 2003
 
I just came across 2 whitepapers from Microsoft that cover Office 2003
migration issues.

2000 - 2003:
http://whitepapers.silicon.com/0,390...000588q,00.htm
XP - 2003:
http://whitepapers.silicon.com/0,390...000588q,00.htm

One point in of of the whitepapers that I found especially interesting
was their recommendation to use late binding. In the past I've heard
(and have repeated to others) that you can just reference the object
library of the oldest version that you plan to support (typically Excel
2000). According to the whitepaper, though, doing so can still lead to
some forward compatibility issues.

Nick Hebb
BreezeTree Software
http://www.breezetree.com



All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com