Error Message - VBE6EXT.OLB could not be loaded

[Matts]

Hi,
I've got an excel aplication developed by myself & is used by atleast 40
diff users. This is not shared & is a stand alone piece for everyone. All
have a personal version of this aplication.

One of the staff has been encountering this particular error on his machine
when
he tries to save the file.."VBE6EXT.OLB could not be loaded". Could you pls
advice on what could this be. Ther was no problem when he tried from another
pc. Looks like this is more Pc related

My aplications accepts data thru a userform & has two other features like
close work book in 10 mnts & has a status bar scroll message as well.

none of the other users have complained abt sucha thing before.

Apreciate any assistance on this.

Thanks, Matthew

 

[Dave Peterson]

I would try repairing or reinstalling excel.

Hi,
I've got an excel aplication developed by myself & is used by atleast 40
diff users. This is not shared & is a stand alone piece for everyone. All
have a personal version of this aplication.

One of the staff has been encountering this particular error on his machine
when
he tries to save the file.."VBE6EXT.OLB could not be loaded". Could you pls
advice on what could this be. Ther was no problem when he tried from another
pc. Looks like this is more Pc related

My aplications accepts data thru a userform & has two other features like
close work book in 10 mnts & has a status bar scroll message as well.

none of the other users have complained abt sucha thing before.

Apreciate any assistance on this.

Thanks, Matthew

 

[James Snell]

I'd log in as another user on that machine just to test for sure. It should
fail if I'm right... If I am then re-register the OLB using regsvr32 using
these commands.

regsvr32 -u <filename>
regsvr32 <filename>

Let us know how that goes.

* instead of typing the path & filename, just drag & drop the file in from
windows explorer, it's much easier & less chance of getting a typo.

 

[yogendrasingh08]

.. 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...

==================================================================

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