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 FilesCommon FilesMicrosoft SharedVBAVBA6
4. VBA add-ins will now work properly.
October 13th, 2009 at 11:09 pm
what is download password?
October 14th, 2009 at 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 at 12:19 am
Thanks yaar…. it worked
February 6th, 2010 at 11:22 pm
It worked. Just follow the steps.
April 5th, 2010 at 11:22 pm
Thanks! It worked for me
July 26th, 2010 at 8:05 am
Am running Office 2010 with Visual Basic 7. I can see a folder for both VBA 6 and VBA 7 in Program FilesCommonFilesMicrosoftShared. Where should I download and run the three files listed above.
Much thanks,
Ken
July 27th, 2010 at 8:52 am
went with it - worked fine.
Thank you.
August 30th, 2010 at 4:36 pm
Do you recognize that this is the best time to receive the loan, which would make you dreams real.