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!

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.

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

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 ?

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

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

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 01, 2013 5:03 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

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! :)

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 02, 2014 8:49 PM
• Unproposed as answer by dvond Wednesday, April 02, 2014 8:50 PM

Thanx it helped me. Had a problem with SW. Now its works. 

Yep, the 64 bit issue.

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

What a mess :)

This worked for me. Thanks Heaps