I found an Excel configuration error: Unable to get the Object property of the OLEObject class

Question

I want to know about OLEObject's nature and where OLEObject is located. I'm not a VBA programmer, but an VBA developer in my office found that error message, and she can't run the Excel VBA program in question on her machine. This program runs completely in another machine.

TylerH · Accepted Answer · 2016-05-09 20:31:28Z

1

I would first ensure ActiveX controls are enabled on her machine. This has been, in my experience, the typical cause when a VBA program will run on one machine but not another.

You could also:

Try activating the object first by using .Activate beforehand
Try referencing the object by its index rather than name

edited May 9, 2016 at 20:31

TylerH

21.3k84 gold badges84 silver badges121 bronze badges

answered Jul 10, 2014 at 14:28

Soulfire

4,3161 gold badge25 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

I found an Excel configuration error: Unable to get the Object property of the OLEObject class

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related