Article ID: 926430
Article Last Modified on 10/15/2007
APPLIES TO
- Microsoft Office Excel 2007
SYMPTOMS
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.
CAUSE
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.
RESOLUTION
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.
Additional query words: XL2007 XL2k7 XL12 Excel2007 Excel2k7 Excel12
Keywords: kberrmsg kbtshoot kbmacro kbconvert kbprb kbfilters kbvba kbexpertisebeginner KB926430