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:
Opening the VBA project in this file requires a component that is not currently installed. This file will be opened without the VBA project. For more information, search Microsoft Office Online for "VBA converters."
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:
Saving this workbook’s VBA project in the Excel 5.0/95 file format requires a component that is not currently installed. Do you want to continue saving in this format?
| • | Click “Yes” to keep this format, which will not save the VBA project.
|
| • | Click “No” to save this file in the latest Excel format. |
To save the VBA project in the Excel 5.0/95 format, search Microsoft Office Online for "VBA converters"
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.
Back to the top
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.
Back to the top
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.
Back to the top
Help and Support
