General discussion

  • Creator
  • #2213435

    MS Office 2003 to 2007 migration, macro issues


    by subbiah durairaj ·

    Hello to every one…

    This is my first post.

    I am currently using MS Office 2003, also have some Excel & Access macro files with same format.

    Now I am going to upgrade version 2007.

    After migration, I want to use all these macro in 2007 version also.

    Can you suggest what are all the changes need to be done in macro codes?

    Also tell me, what are the macro related issues are these on 2003-2007 conversion.

    Thank You.

All Comments

  • Author
    • #2870889

      I haven’t seen any major issues.

      by charliespencer ·

      In reply to MS Office 2003 to 2007 migration, macro issues

      At least, not with the macros themselves.

      You’ll want to add the Developer tab to the Ribbon. It’s part of Office but not installed by default. Just right-click the Ribbon, select Customize, and click the Developer check box. It will give you access to the Macro controls.

      Save a copy of your 2003 files, open them in 2007, and then save them in the new formats. Your macros should be okay. Be aware that upgrading a 2003 Access database to 2007 is irreversible (just like upgrading from one version of Access to another has always been), and the database will not be accessible to other still running 2003.

      If you created toolbar shortcuts to your macros, you’ll have to recreate them in 2007. Shortcuts from the 2003 toolbars don’t migrate to the new 2007 ‘Ribbon’ toolbar format.

Viewing 0 reply threads