January 31, 2012

  

Solution to "VBE6EXT.OLB could not be loaded." Error

By    on    with  4 comments
I got a VBE6EXT.OLB could not be loaded error when I wanted to install this really great tool-set for Excel that I've been using for years form http://www.asap-utilities.com on my new machine which has MS Office 2010 installed.

So I found this solution posted on Solidworks forum after some Google digging:

Make sure the following items exist in your registry:

[HKEY_CLASSES_ROOT\TypeLib\{0002E157-0000-0000-C000-000000000046}]


[HKEY_CLASSES_ROOT\TypeLib\{0002E157-0000-0000-C000-000000000046}\5.3]
"PrimaryInteropAssemblyName"="Microsoft.Vbe.Interop, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"
@="Microsoft Visual Basic for Applications Extensibility 5.3"


[HKEY_CLASSES_ROOT\TypeLib\{0002E157-0000-0000-C000-000000000046}\5.3\0]


[HKEY_CLASSES_ROOT\TypeLib\{0002E157-0000-0000-C000-000000000046}\5.3\0\win32]
@="C:\\Program Files (x86)\\Common Files\\Microsoft Shared\\VBA\\VBA6\\VBE6EXT.OLB"


[HKEY_CLASSES_ROOT\TypeLib\{0002E157-0000-0000-C000-000000000046}\5.3\FLAGS]
@="0"


[HKEY_CLASSES_ROOT\TypeLib\{0002E157-0000-0000-C000-000000000046}\5.3\HELPDIR]
@="[{0002E157-0000-0000-C000-000000000046}]"

Note: You could download & import the above registry keys into your registry as a .reg file from the original post below.

Source: https://forum.solidworks.com/thread/40593


Share:

4 comments:

  1. ArvindApril 12, 2015

    Thanks! It worked.

    ReplyDelete
  2. AnonymousOctober 05, 2015

    I thank you also. It worked.

    ReplyDelete
  3. EdwinMay 25, 2020

    Thank you sir, it worked for MSOffice2019 @W8.1

    ReplyDelete
  4. UnknownOctober 24, 2020

    Thank you sooooo much I am searching solution since an year. Just downloaded the zip file and double clicked problem solved.

    ReplyDelete