Trying to create Excel spreadsheets (programmatically) on a Windows 2008 64-bit server with Office 2007 installed.
Error: Can’t create objects
I have the same code working on another Windows 2008 server running Office 2003.
can you update us on this issue? Did you make any progress or by any chance solve it? Please let us know. Thank you!
In the VBEditor, under Tools-Options on
the General tab, do you have Break on all errors set? Changing the option to Break on Unhandled
Error may solve the problem
error 429 "ActiveX component can't create object
Most likely a DLL that is required to create whatever object it is attempting to instatiate is not properly registered with the system. Without knowing what it is trying to create, I can't speculate what DLL is the issue.