Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
liminma8458
2968 Views, 18 Replies

Ilogic fails to talk to Excel

Hi,

 

I am using Inventor 2016, Excel 2013, windows 7 64 bit.

 

I have very simple iLogic rule:

iwood_supp_thk=GoExcel.CellValue("cc_data.xls", "Sheet1", "wood_supp_thk").

 

It works well for all other machines. But it fails in one particular machine. The message says:

 

Error in rule: block4_scenario3, in document: block4_scenario3.ipt

 

Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel.Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

 

Looks like the iLogic does not talk to Excel correctly. I re-install Inventor and Excel a couple of times, and use the sequence of installing Office first then Inventor secondly.

 

Please see attached file for the error message.

 

What is it? Can somebody help?

 

Thank you very much!

 

Limin

 

 

 

 

 

 

Thanks
Limin
Inventor pro 2023 64 bit update 2.1; Windows 10 pro 64 bit version 21H2; Office 2013 32 bit