How to Convert Excel 2003 Macros to Excel 2007

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Convert Excel 2003 Macros to Excel 2007
(computer image by blaine stiger from

Microsoft Visual Basic for Applications (VBA) is essentially the same in Excel 2003 as it is in Excel 2007. If you open your Excel 2003 file (XLS) and save it as an Excel 2007 file (XLSX), the macros should transfer over intact. If they don't, it isn't because your code has failed to convert. One of two things has happened: either you haven't set the macro settings in Excel 2007, or your workbook (not the code itself) is corrupt. A workaround for the problem is to save the macros as text files and transfer them over individually from Excel 2003 to Excel 2007.

Skill level:


  1. 1

    Click on the "Office" Button.

  2. 2

    Select "Excel Options."

  3. 3

    Choose "Trust Center->Trust Center Settings->Macro Settings."

  4. 4

    Click on "Trusted Locations->Add New Trusted Locations."

  5. 5

    Add your workbook's location and then select "OK."

  6. 6

    Open the workbook again in Excel 2007 and check for working macros. If they still don't work, you'll need to copy and paste the macro text over (see Section 2).

  1. 1

    Open the workbook in Excel 2003.

  2. 2

    Locate the code for your macro. An easy way to locate code for a particular macro is to click on the "Tools" menu, and then "Macro->Macros." Find the macro name and then click "Edit."

  3. 3

    Highlight the entire section of code and then press "Ctrl" and "C."

  4. 4

    Paste the text into a text file (using a program like Notepad or Wordpad).

  5. 5

    Open the VBE in Excel 2007 and paste the code into a new code window.

Tips and warnings

  • A shortcut to opening the VBE window is to press "Alt" and "F11" together.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.