Our Development team is well aware of this current issue, and are working on updates to correct/avoid the problem. With the newer Office 365 click-to-run model, though, it has been a bit of a challenge, to say the least. AutoCAD Electrical has always needed the Access Database Engine and Office updates haven't usually had this kind of severe impact on us. The shift from the traditional way that Office has always operated is really at the heart of this issue. You're spot-on with the link to the Microsoft write-up about this issue. Nick, thanks so much for putting this together in such detail. This has caused me a whole day's worth of pain, but hopefully it will help someone else out I've done a quick check with AutoCAD Electrical 2021 and it seems OK I've only tested this with AutoCAD Electrical 2022 & Excel Version 2203 Build 15028.20204 Download Microsoft Access 2013 Runtime (64 bit) from here.Repair Office 365 (a quick repair worked fine for me).Uninstall all versions of Microsoft Access Runtime.In summary, these are the steps to follow if you are having issues reading & writing Excel files in AutoCAD Electrical These are Microsoft 365 Access Runtime, which did not work, or Microsoft Access 2013 Runtime which allowed me to use AutoCAD Electrical 2022 Using a standalone program to test Excel Interop, I found that uninstalling the Access Database Engine & repairing Office 365 would fix Excel Interop, & that it was the Access Database Engine that was breaking thingsįurther searching came up with this document from Microsoft - which explains the issue, and offers two possible solutions. Most suggestions from these forums & Google involve repairing Office, and reinstalling the Access Database Engine 2016, which would get me back to the same point, but would not fix the Excel issue "Unable to cast COM object of type '.ApplicationClass' to interface type '._Application'"
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |