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.

--

Dave Peterson

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

[yogendr...@gmail.com]

. 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

[Jean Luc Rebourg]

Hi,
After having tried several solutions without any result, I tried the "yogendr...@gmail.com" one.
As indicated, I added the "developper menu", and clicked on Visual Basic, after having moved the vbe6ext.OLD elsewhere.
As expected, EXCEL proposed me to repair the program, and I accepted, but soon the same message appeared again : "cannot load vbe6ext.OLD" (or something like that).
I was desappointed and I closed all, but when I retried to open VB un EXCEL, it worked !!!
So it seems to be good.
Thanks a lot !!