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

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.

I found the solution posted on the 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

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

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

undefined

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

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

undefined

Excel -- Worksheet VLookp Functions

This and more Excel tips can be found on http://www.contextures.com/tiptech.html

Excel VLOOKUP Function and VLOOKUP Example

In a workbook, you can create a table that stores information about your products, or employees, or other data you want to refer to frequently. From other cells in the workbook, you can use an Excel VLOOKUP formula to look up data from the master table.