Microsoft KB Archive/813970

= Error message when you cancel the installation of Visual Basic for Applications: &quot;An error occurred&quot; =

Article ID: 813970

Article Last Modified on 2/14/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003

-



SYMPTOMS
If you cancel the installation of Microsoft Visual Basic for Applications (VBA) in Microsoft Excel, you may receive an error message that is similar to the following:

An error occurred initializing the VBA libraries (1004)



CAUSE
This behavior can occur when all of the following conditions are true:
 * If VBA is set to install on first use when you install Excel or Microsoft Office.

-and-
 * You have not yet used VBA in this installation of Excel or Microsoft Office.

-and-
 * You press ALT + F11 to open Visual Basic Editor, and then click No when prompted to install VBA.



RESOLUTION
To prevent this issue from occurring, follow these steps to install VBA:
 * 1) Start Excel.
 * 2) You press ALT + F11 to open Visual Basic Editor.
 * 3) When prompted to install VBA, click Yes.

Additional query words: Additional query words: XL2003 XL2007

XL2002 prb OfficeErrorMessages 10045

Keywords: kbprb KB813970

-

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

© Microsoft Corporation. All rights reserved.