Error - vbe6ext.olb could not be loaded

Issue description:


The target PC has both Office 2010 and 2016 installed, after uninstalled the Office 2016, and open an Excel Spreadsheet, the above error happened.





Fix:


Go to below folder:
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6
Rename the file "VBE6EXT.OLB" to "VBE6EXT.OLD”.

Open Excel again, click Alt+F11, a popup window prompting for repairing, click "Yes".



After repair completed, the problem is fixed also.

Comments

  1. vineeshvs2 July 2020 at 00:49

    VBA folder is not present in C:\Program Files\Common Files\Microsoft Shared
    What to do?

    ReplyDelete

Post a Comment

Popular posts from this blog

Visual Studio $(TargetDir) macro is empty

I encounter this issue in VS2017, it shall apply to older version also. To repeat the issue: 1. Create a PreBuildEvent, and type below script echo TargetDir = "$(TargetDir)" 2.  Build the project, you will see: TargetDir = "" Solution: Open the project file with a text editor, then remove the PreBuildEvent section, including the outer <PropertyGroup>. Then re-add the Pre Build Events using Visual Studio.   <PropertyGroup>     <PreBuildEvent>          <!-- Pre build commands go here -->     </PreBuildEvent>   </PropertyGroup>
Read more