Opening the VBA project in this file requires a component that is not currently installed
Posted on | September 2, 2009 |
The Problem:
Receiving one of the following errors when opening Excel:
“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’.”
Or
“Excel was able to open the file by repairing or removing the unreadable content. This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.”
The Resolution:
1. Close all Office applications.
2. Download the following DLL files (Depending on your browser you may be able to save these files directly to the location indicated in step 3):
VBACV10.DLL
VBACV10D.DLL
VBACV20.DLL
3. Save the downloaded .dll files in C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6
4. VBA add-ins will now work properly.
Related Posts
Comments
4 Responses to “Opening the VBA project in this file requires a component that is not currently installed”
Leave a Reply
October 13th, 2009 @ 11:09 pm
what is download password?
October 14th, 2009 @ 6:54 am
There should not be any passwords to download these files, dlldump.com should be free. In any case I will email you the files.
November 13th, 2009 @ 12:19 am
Thanks yaar…. it worked
February 6th, 2010 @ 11:22 pm
It worked. Just follow the steps.