ActiveX component can't create object Excel.Application

Question

My code, running in MS Access 2010:

Sub test()
    Dim xl as Object
    set xl = CreateObject("Excel.Application")
End Sub

For whatever reason I am getting the error

ActiveX component can't create object.

I don't know why -- I go to Tools -> References and I even add the Microsoft Excel library, but still nothing.

Did you try any of the solutions posted here stackoverflow.com/questions/656934/… — Bassie
– Bassie, Commented Oct 26, 2017 at 15:36
I don't think any of those solutions apply to this specific scenario -- this code works from the MS Access .mdb databases but not the newer .accdb ones. — user8838318
– user8838318, Commented Oct 26, 2017 at 15:38
@ErikvonAsmuth Yes but that's only because I went back and included the reference (Early binding I believe), the late binding is not working though as per the original post — user8838318
– user8838318, Commented Oct 26, 2017 at 15:39

Gordon Prince · Accepted Answer · 2017-10-27 14:39:19Z

3

Sometimes creating objects and not releasing them when you're finished can get things fouled up. Check your Task Manager and see if there are multiple "excel.exe" tasks running. Also note by default when they are created, they do not become visible unless you set the property after instantiating the object variable.

Sometimes rebooting the PC and trying this first will work. If it works after a fresh reboot, then stops working, something's not getting released properly.

answered Oct 27, 2017 at 14:39

Gordon Prince

1512 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

ActiveX component can't create object Excel.Application

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