locked
'VBE6EXT.OLB' could not be loaded RRS feed

  • Question

  • Hi!

    This is my first ever post to TechNet, so please be gentle!

    I have an issue with Office 2007 AND 2003, moreover Excel 2007 and 2003. This is over a few computers, running different versions of Windows (XP and W7).

    Whenever I try to open up VBA or any macro it throws up an error message (stated in the title), followed by a further error message "Out of Memory"

    After some fairly extensive research on the matter I have ruled out the following options (tried and failed):

    • Disable any Add-ins that may be causing a problem (I disabled ALL Add-ins)

    • Detect and repair

    • Uninstall/Reinstall

    • Check permissions on registry key HKCR\Typelib\{0002E157-0000-0000-C000-000000000046}, set Everyone to 'Full Control'

     

    I'm completely out of ideas!

     

    Please can you help?

     

    Many thanks!

    Tuesday, September 14, 2010 3:50 PM

All replies

  • Hi,

    Do you have Microsoft Visual Basic installed on the computer? Which version of SolidWorks is installed in the computer?

    VBE6EXT.OLB is Visual Basic Extensibility. It could be possible that VBE6EXT.OLB which is required to run SolidWorks is corrupted. See if you can repair the installation. If it doesn’t, reinstalling it should fix the problem.

     

    Method 1: Repair SolidWorks

     

    Some programs include the option to change or repair the program in addition to uninstalling it. Follow these methods to check if SolidWorks have the repair option.

     

    a.    Go to Start, type “appwiz.cpl” without the quotes and press Enter.

    b.    Locate SolidWorks and click on it.

    c.    See if Repair option is available. If so, click on it.

     

    Once repair is complete, see if SolidWorks load properly.

     

    Method 2: Uninstall and reinstall SolidWorks.

     

    Step 1:

     

    a.    Follow the above method to navigate to SolidWorks.

    b.    Click on the Uninstall button.

     

    Step 2:

     

    Reinstall the program by locating its setup file.

     

    Refer:

     

    Uninstall or change a program

    Hope it helps.

    • Proposed as answer by Jan Malan Friday, October 23, 2015 3:06 PM
    • Unproposed as answer by Jan Malan Friday, October 23, 2015 3:06 PM
    • Proposed as answer by Kainat Mirza Monday, February 4, 2019 8:33 PM
    Wednesday, September 15, 2010 1:58 AM
  • Hi Jennifer,

    Thanks very much for your response, I really appreciate it.

    Unfortunately SolidWorks is not installed on any of the machines in question.

    Would it be an idea just to remove the file and reference entirely? If so, how would you recommend going about this?

    Failing that, would you be able to recommend a means of locating any dependencies for that file? It may give me more clues as to which program it is referring to....

     

    Thanks again,

     


    Sam

    Wednesday, September 15, 2010 9:00 AM
  • hi !

    This issue happens with my autodesk inventor 2011.When i open macro utility.I updateed window up to win 7 sp1 RC and reinstall office 2010.But nothing is better.

    somebody has a better way ?

    Tuesday, February 15, 2011 10:11 AM
  • Hello,

    easy issue found!

    1. Close excel program.

    2. find the file vbe6ext.olb in C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6

    3. rename the file to vbe6ext.OLD

    4. open excel program and go to "developper menu", if you don't have this menu, right click in the ribbon menu, "customize the ribbon" and check "developper" at right list

    5. click on "visual basic" to open it

    6. a pop up window comes to ask if you want repair the programme, clic yes

    7. leave running the repair

    8. close excel and reopen it...

    that's it!

    Have a good day!

    Pascal.

    • Proposed as answer by Brightner Tuesday, March 19, 2013 12:06 AM
    Friday, September 21, 2012 9:58 AM
  • Hello,

    easy issue found!

    1. Close excel program.

    2. find the file vbe6ext.olb in C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6

    3. rename the file to vbe6ext.OLD

    4. open excel program and go to "developper menu", if you don't have this menu, right click in the ribbon menu, "customize the ribbon" and check "developper" at right list

    5. click on "visual basic" to open it

    6. a pop up window comes to ask if you want repair the programme, clic yes

    7. leave running the repair

    8. close excel and reopen it...

    that's it!

    Have a good day!

    Pascal.


    Thank you very much for the solution, it worked for me I was really worried because I couldnt use VBA in excel I did everything I found on the web, and the only solution that worked was yours, thank you again.
    • Proposed as answer by Brightner Tuesday, March 19, 2013 12:06 AM
    • Unproposed as answer by Brightner Tuesday, March 19, 2013 12:06 AM
    • Proposed as answer by romyr Saturday, September 19, 2015 5:44 PM
    • Unproposed as answer by romyr Saturday, September 19, 2015 5:44 PM
    • Proposed as answer by Mr TW Tuesday, January 23, 2018 5:09 PM
    Saturday, September 29, 2012 7:02 PM
  • Running Office 2010 (32bit) on a Windows 7 64bit OS seems to cause this issue for me.

    Resolution was:

    Copy
    C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB
    To
    C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB

    Silly i know, but it worked for me :)

    • Proposed as answer by Dulce García Tuesday, October 1, 2013 5:03 AM
    Tuesday, May 21, 2013 10:54 AM
  • Yeeees!!! It absolutely worked for Windows 8 too.

    I had problems with EXCEL and Solid Works but it simply solved both of them for me.

    Thank you Matt

    Tuesday, October 1, 2013 5:03 AM
  • I know this is an old thread now but thanks to both Pascal for the fix and Matt for the updated Win7x64 path this solved this minor annoyance for me too.

    So Many thanks both, much appreciated! :)

    Friday, March 21, 2014 12:32 PM
  • Old thread but provided just the answer. Renaming to .OLD did not work for me, but...

    Copy
    C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB
    To
    C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB

    ...did work for me.

    There was no VBA6 folder C:\Program Files\... just a VBA7 folder, so I just created one.

    Try both solutions, one should work. Thanks again!

    • Proposed as answer by dvond Wednesday, April 2, 2014 8:49 PM
    • Unproposed as answer by dvond Wednesday, April 2, 2014 8:50 PM
    Wednesday, April 2, 2014 8:49 PM
  • Thanx it helped me. Had a problem with SW. Now its works. 
    Friday, April 25, 2014 7:02 AM
  • Yep, the 64 bit issue.

    Just copy the VBA6 folder from x86 to the other location.

    What a mess :)

    Monday, October 13, 2014 7:51 AM
  • This worked for me. Thanks Heaps
    Friday, July 31, 2015 12:53 AM
  • After my windows upgraded to Windows10 I could not run macros and if I try to open visual basic editor in excel 2010 I got the same error. 

    'VBE6EXT.OLB' could not be loaded

    Tried everything, reinstall office, download tools, and copy directories. Nothing worked, then I decided to change the security permissions of the file vbe6ext.olb and add permission for every one.

    Who-la I can program macros again.

    Should have thought about permissions the first day instead I googled and got no were

    • Proposed as answer by Jan Malan Friday, October 23, 2015 3:17 PM
    Friday, October 23, 2015 3:17 PM
  • I tried below but did not work:

    1. rename the file vbe6ext.OLB from to vbe6ext.OLD as indicated in this thread.

    2. uninstall and reinstall

    3.Copy
    C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB
    To
    C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB

    as indicated in this thread.

    4.add permission for every one as indicated in this thread.

    Finally I copy vbe6ext.OLB to C:\Program Files\Common Files\microsoft shared\VBA\VBA7 and C:\Program Files\Common Files\microsoft shared\VBA\VBA7.1 and it works!!!!


    Friday, November 6, 2015 1:23 AM
  • I tried below but did not work:

    1. rename the file vbe6ext.OLB from to vbe6ext.OLD as indicated in this thread.

    2. uninstall and reinstall

    3.Copy
    C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB
    To
    C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB

    as indicated in this thread.

    4.add permission for every one as indicated in this thread.

    Finally I copy vbe6ext.OLB to C:\Program Files\Common Files\microsoft shared\VBA\VBA7 and C:\Program Files\Common Files\microsoft shared\VBA\VBA7.1 and it works!!!!


    Hi Allan!

    I tried every single thing in this thread for like an hour and I am running Win8 64Bit. I was about to quit trying then I saw your solution, which is the last comment in this section. And it finally worked! Guess one last try brings you miracle :)

    Thank you very much for sharing it!!!!

    Cheers,

    Amanda

    Monday, January 25, 2016 11:50 AM
  • This is workable for me. Thanks!
    Friday, January 29, 2016 12:00 PM
  • I have the same problem but I don't even have the file vbe6ext.OLB because my solidworks is 2016.

    I have common files/Microsoft shared/VBA/VBA7.1/1046/ and there there are seven items with the extension .CHM

    Any suggestions?

    Thanks

    Tuesday, May 10, 2016 10:08 PM
  • This is a MIRACLE!!!!! THANKS!!! 
    Tuesday, June 28, 2016 7:01 AM
  • I love you for this, it worked for me. <3 Thank you Dulce.
    Monday, August 15, 2016 2:00 AM
  • Running Office 2010 (32bit) on a Windows 7 64bit OS seems to cause this issue for me.

    Resolution was:

    Copy
    C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB
    To
    C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB

    Silly i know, but it worked for me :)

    Hi... Unfortunately I don't have the file 'VBA' in Program Files(x86) or Program files. I don't have SolidWorks either. So none of the solutions work for me. What should I do? I have already tried reinstalling excel several times. Could anyone help me? Many thanks!
    Saturday, November 12, 2016 2:19 AM
  • I GENERALLY DONT REPLY ON ANY BLOGS.

    BUT I COULD NOT RESIST TO THANK YOU DEAR FOR THIS SOLUTION.

    I WANDERED FOR HOURS BEFORE YOUR METHOD TO SOLVE THE ISSUE.

    THANK YOU VERY MUCH.

    Wednesday, April 5, 2017 9:40 AM
  • Worked for me too
    Wednesday, August 9, 2017 10:17 AM
  • Brilliant
    I kept for the last three days
    But every effort failed
    But a solution was solved in one second of your way
    thank you very much

    Noor Wazir,Pakistan

    Thursday, December 20, 2018 5:50 AM
  • When I try to open VB 6.0 then the setup shows this Massage
    "VB6EXT.OLB" Could not be registered
    Can you tell me Now what to do?
    According to your instructions I did all things but I didn't found it.
    Sunday, February 3, 2019 6:16 AM
  • Try all, at least one of them should help:

    C:\Program Files\Common Files\microsoft shared\VBA\VBA6\VBE6EXT.OLB
    C:\Program Files\Common Files\microsoft shared\VBA\VBA7\VBE6EXT.OLB
    C:\Program Files\Common Files\microsoft shared\VBA\VBA7.1\VBE6EXT.OLB
    C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB
    C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7\VBE6EXT.OLB
    C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE6EXT.OLB

    Monday, August 5, 2019 7:57 PM
  • Thank you so much for your post! I've trawled the net for hours and your post is the one that worked for me, the registry key permissions to full control for applications fixed it...

    I did things backwards using the copy fixes described below for the file VBE6EXT.olb

    Thank you enormously! <3, you are a legend!

    Also everyone else who has posted here, you're all awesome :D



    Sunday, February 9, 2020 2:53 PM