- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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