I am trying to open excel from vba code in Access 2010 using the GetObject function.
My code is as follows:
dim xlObj as Object
Set xlObj = GetObject(, "excel.application")
I get the following error on the second line:
Run-time error '429':
ActiveX component can't create object
What is strange is that this was working for a few iterations and now it doesn't.
The first time if failed I did a decompile of the data base and that got it to work for one time. But then if failed with the same message again.
Any ideas on what is causing this?