Error message when you try to open an Excel 5.0/95 workbook that contains a VBA module sheet in Excel 2007: "Opening the VBA project in this file requires a component that is not currently installed"

When you try to open a Microsoft Excel for Windows 5.0/95 workbook that contains a Visual Basic for Applications (VBA) module sheet in Microsoft Office Excel 2007, you receive the following error message: When you try to save an Excel 2007 workbook that contains VBA projects in the Microsoft Excel 5.0/95 Workbook (*.xls) file format, you receive the following error message:

This issue occurs because Excel 2007 does not directly support the conversion of macros that are written by using Excel 5.0/95 VBA. The VBA Converter Pack is not included as part of the 2007 Microsoft Office suites. The VBA Converter Pack must be installed separately. See the “How to Obtain the Converter" section for instructions on how to obtain the VBA Convertor Pack.

Note Although the VBA Converter Pack for Microsoft Office Excel 2007 will convert VBA module sheets in the Excel 5.0/95-formatted workbook, the VBA Convertor Pack will remove all VBA projects and any COM-based controls that were in the worksheets of the workbook.

To resolve this issue, you must export each module in the Excel 5.0/95 workbook, remove the module, and then import that module back into the workbook. To do this, follow these steps.

1. If you have Microsoft Office Excel 2003 or earlier versions of Excel, open the Excel Workbook in that program.
   
   However, if you do not have access to Excel 2003 or earlier versions of Excel, you will have to install the VBA Convertor Pack for Excel 2007, and then open the Excel Workbook in Excel 2007.
2. Press ALT+F11 to open the Visual Basic Editor.
   
   All the VBA modules in the Excel Workbook are now displayed.
3. For each module in the Visual Basic Editor, follow these steps:
   1. In the Project Explorer pane, right-click the module, and then click Remove Module_name.
      Where the placeholder Module_name is the module that you want to export and remove.
   2. Locate a folder that you want to save the modules in and then click Save. The module is removed after it is saved.
   3. Right-click VBAProject (Workbook_name) and then click Import File.
      Where the placeholder Workbook_name is the name of the workbook that the module was attached to.
   4. Locate the folder where you saved the module that you exported.
   5. Select the module file and then click Open. The module is displayed in the Project Explorer pane.
4. On the File menu, click Close and return to Microsoft Excel.
5. After you have exported and imported all the modules, save your workbook.

How to Obtain the Converter

To resolve this issue, contact Microsoft Customer Support Services to obtain the VBA Convertor Pack. For a complete list of Microsoft Customer Support Services telephone numbers and for information about support costs, visit the following Microsoft Web site: NoteThe VBA Convertor Pack is provided free of charge. However, if you have additional questions or issues or if any troubleshooting is required, a separate service request will be created. The usual support costs will apply to additional support questions and issues that do not directly involve obtaining and installing the VBA Convertor Pack.