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: Additionally, although the VBA Converter Pack for Microsoft Office Excel 2007 will convert VBA module sheets in the Excel 5.0/95-formatted workbook, all VBA projects and any COM-based controls that were in the worksheets of the workbook will be removed.

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.

To resolve this issue, contact Microsoft Product Support Services. For a complete list of Microsoft Product Support Services telephone numbers and for information about support costs, visit the following Microsoft Web site: Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.