CODEWITHSUNDEEP
excelvbams-accessms-access-2010activex
user8838318
user8838318

Reputation: 21

ActiveX component can't create object Excel.Application

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.

Upvotes: 2

Views: 19216

Answers (1)

Gordon Prince
Gordon Prince

Reputation: 151

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.

Upvotes: 3

Related Questions