Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macros (2000 to 2003)

    We are upgrading to 2003 from 2000 and have thousands of macros on many workbooks. Are we going to have a major catastrophe or is there not much that can go wrong?
    Neil Eustice
    Woody Worshipper

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Macros (2000 to 2003)

    Hi Neil

    VBA has only changed a little from 2000 to 2003, with most of the changes relating to new features. Therefore on paper going from 2000 to 2003 should not cause problems but in practice you will find some routines will stop working or produce unexpected results. It may also not be apparent what the problem is.

    As an example if you set Application.ScreenUpdating to False in 2000 then when the macro finishes Excel would automatically turn sreenupdating back on. From 2002 you can find that screenupdating would not be turned back on and have to explicity turn it back on. This can make it appear that Excel has stopped working.

    Good luck with the update and I hope any problems you get are small.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macros (2000 to 2003)

    Good to hear.

    Thanks for the good news.
    Neil Eustice
    Woody Worshipper

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macros (2000 to 2003)

    While I personally have not had significant coding issues on the upgrade, you might like to run a Lounge Search on Excel posts by <!profile=jujuraf>jujuraf<!/profile>. She has a great deal of experience on coding compatibility issues between the various versions of Excel. She has, from time to time, pointed out where code features have inexplicably become incompatible between versions. HTH
    Gre

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •