Microsoft KB Archive/926430

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

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:

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 &quot;VBA converters.&quot;

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 &quot;VBA converters&quot;

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:

http://support.microsoft.com/contactus/?ws=support

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.