Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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é
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default 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é

  #3   Report Post  
Posted to microsoft.public.excel.programming
JNW JNW is offline
external usenet poster
 
Posts: 480
Default 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é

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Excel 4.3 macro migration JDT Excel Discussion (Misc queries) 3 November 22nd 06 11:30 PM
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? brigida3 Excel Discussion (Misc queries) 1 January 22nd 06 05:13 PM
Excel macro migration resources Scott Excel Programming 1 January 29th 04 05:32 AM
regarding Excel 97 to XP migration / conversion?? Norman Fritag Excel Programming 2 November 27th 03 12:06 PM
Migration of Excel97 to Excel XP Peter[_27_] Excel Programming 2 September 16th 03 10:56 AM


All times are GMT +1. The time now is 12:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"