Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
Anonymous
in reply to: liminma8458

Hello,

 

I am running into the same issue, I wrote an iLogic rule using Inventor 2015 w/ excel 2010 which worked without any issues. Upgraded Inventor to 2016 (Excel still 2010) and now Inventor can't seem to talk to Excel. Help would be greatly appreciated.

 

Thanks,

'Funnybus

 

Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' 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)).

 

 

SyntaxEditor Code Snippet

oExcelPath = "G:\FSH_Engineering\ENGINEERING DRAWINGS\_DRAWING TEMPLATES\_INVENTOR\_START PARTS\UTILITY\GAUGE.xlsx"

Dim oListGauge As New ArrayList
Dim oListThick As New ArrayList

Dim oListHolder As String

Dim i As Integer

For i = 1 To 50 Step 1
    Dim oValGauge As String = GoExcel.CellValue(oExcelPath, "Sheet1", "A" & i)
    Dim oValThick As Double = GoExcel.CellValue(oExcelPath, "Sheet1", "B" & i)
    Dim sValThick As String = oValThick.ToString("0.0000")
        If oValThick = 0 Then
            'do nothing
        Else
            oListGauge.Add(oValGauge)
            oListThick.Add(sValThick)
            oListHolder = oListHolder & sValThick & " // " & oValGauge & vbLf
        End If
Next

'MessageBox.Show(oListHolder, "List of Gauge & Thickness")

MultiValue.List("GAUGE") = oListGauge
MultiValue.List("THICKNESS_GAUGE") = oListThick

Fails at first instance of GoExcel.CellValue