ERROR NUMBER:= 91

Steffmeister

Board Regular
Joined
Nov 7, 2005
Messages
195
Hi guys,

I got a little problem when I start Excel.
I get a popup what says:

Error number:= 91
Error discrp:= Object variable or With block variable not set
You may have to manually set a reference to the [VBIDE = VBE6EXT.OLB]

Does somebody know what I must do now?

Grts. Stephan
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Ceduljko

Board Regular
Joined
Dec 28, 2004
Messages
58
Steff,

PRess Alt+F11 to go to the Visual Basic editor, in the left panel (Project - VBA Project) select a 'potential' troublemaker (freshly added some add-in?) and go to Tools > References.

Once in the References, click on Browse and add the reference to the missing file:

"C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\vbe6ext.olb"

Don't forget to Save the file.
 

Steffmeister

Board Regular
Joined
Nov 7, 2005
Messages
195
Hi Ceduljko,

What do you mean with 'select a 'potential' troublemaker (freshly added some add-in?)'.
How can I select it?

Grts. Stephan
 

Ceduljko

Board Regular
Joined
Dec 28, 2004
Messages
58
Usually, "in the left panel (Project - VBA Project)" you would see several VBA Projects. One of them is causing your problem. Most of the time, problem arises immediately after some changes were added to the system, like installation of an plug-in, or add-on...
 

Watch MrExcel Video

Forum statistics

Threads
1,118,327
Messages
5,571,560
Members
412,405
Latest member
DutchMonkey
Top