I had an Excel sheet working nicely with Creo 2, and all of a sudden I started getting automation errors while trying to connect. The error is "Run-time error 2147417851 (80010105), Automation error. The server threw an exception."
The only way I can clear it is to restart the PC. It will work fine a few times, and then throw it again. I can't find anything that would cause it, and it always happens while trying to connect.
Set oConn = oAsynConn.Connect (Null, Null, Null, 5).
Once it trips, I get the error regardless if I stop and restart excel, and it doesn't matter if Creo is open or not. It also happened when I tested on a different machine with the same spreadsheet. I've unregistered/re-registered the component, checked the references, etc. All looks fine.
Solved! Go to Solution.
This error should be related to Excel, not to connect. I would suggest to check how is the Excel object created.
Try to google this error number, there are many issues on this error code - for example this on: run-time error '-2147417851 (80010105)'