<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Ilogic fails to talk to Excel in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6398574#M64900</link>
    <description>&lt;P&gt;Hello&amp;nbsp;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/553194"&gt;@liminma8458﻿&lt;/a&gt;,&lt;/P&gt;
&lt;P&gt;I will ask the forum moderator to move this post to the Inventor Customization Forum where this question is better served.&lt;BR /&gt;Best Regards,&lt;BR /&gt;Don&lt;/P&gt;</description>
    <pubDate>Wed, 22 Jun 2016 17:39:46 GMT</pubDate>
    <dc:creator>ADSKDJW4</dc:creator>
    <dc:date>2016-06-22T17:39:46Z</dc:date>
    <item>
      <title>Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6394685#M64899</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I am using Inventor 2016, Excel 2013, windows 7 64 bit.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I have very simple iLogic rule:&lt;/P&gt;
&lt;P&gt;iwood_supp_thk&lt;STRONG&gt;=&lt;/STRONG&gt;&lt;STRONG&gt;GoExcel&lt;/STRONG&gt;.&lt;STRONG&gt;CellValue&lt;/STRONG&gt;&lt;STRONG&gt;(&lt;/STRONG&gt;"cc_data.xls", "Sheet1", "wood_supp_thk"&lt;STRONG&gt;)&lt;/STRONG&gt;.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;It works well for all other machines. But it fails in one particular machine. The message says:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Error in rule: block4_scenario3, in document: block4_scenario3.ipt&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;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)).&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Looks like the iLogic does not talk to Excel correctly. I re-install Inventor and Excel&amp;nbsp;a couple of times, and use the sequence of installing Office first then Inventor secondly.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Please see attached file for the error message.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;What is it? Can somebody help?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thank you very much!&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Limin&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 20 Jun 2016 22:05:18 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6394685#M64899</guid>
      <dc:creator>liminma8458</dc:creator>
      <dc:date>2016-06-20T22:05:18Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6398574#M64900</link>
      <description>&lt;P&gt;Hello&amp;nbsp;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/553194"&gt;@liminma8458﻿&lt;/a&gt;,&lt;/P&gt;
&lt;P&gt;I will ask the forum moderator to move this post to the Inventor Customization Forum where this question is better served.&lt;BR /&gt;Best Regards,&lt;BR /&gt;Don&lt;/P&gt;</description>
      <pubDate>Wed, 22 Jun 2016 17:39:46 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6398574#M64900</guid>
      <dc:creator>ADSKDJW4</dc:creator>
      <dc:date>2016-06-22T17:39:46Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6808351#M69349</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;'Funnybus&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;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)).&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;SyntaxEditor Code Snippet&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;oExcelPath&lt;/SPAN&gt; &lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;G:\FSH_Engineering\ENGINEERING DRAWINGS\_DRAWING TEMPLATES\_INVENTOR\_START PARTS\UTILITY\GAUGE.xlsx&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oListGauge&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;New&lt;/SPAN&gt; &lt;SPAN&gt;ArrayList&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oListThick&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;New&lt;/SPAN&gt; &lt;SPAN&gt;ArrayList&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oListHolder&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;i&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Integer&lt;/SPAN&gt;

&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;i&lt;/SPAN&gt; &lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;1&lt;/SPAN&gt; &lt;SPAN&gt;To&lt;/SPAN&gt; &lt;SPAN&gt;50&lt;/SPAN&gt; &lt;SPAN&gt;Step&lt;/SPAN&gt; &lt;SPAN&gt;1&lt;/SPAN&gt;
    &lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oValGauge&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; &lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;&lt;SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN&gt;CellValue&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;oExcelPath&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;Sheet1&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;A&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt; &lt;SPAN&gt;&amp;amp;&lt;/SPAN&gt; &lt;SPAN&gt;i&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;
    &lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oValThick&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Double&lt;/SPAN&gt; &lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;&lt;SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN&gt;CellValue&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;oExcelPath&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;Sheet1&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;B&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt; &lt;SPAN&gt;&amp;amp;&lt;/SPAN&gt; &lt;SPAN&gt;i&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;
    &lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;sValThick&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; &lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;oValThick&lt;/SPAN&gt;&lt;SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN&gt;ToString&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;0.0000&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;
        &lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oValThick&lt;/SPAN&gt; &lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;0&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt;
            &lt;SPAN&gt;'&lt;/SPAN&gt;&lt;SPAN&gt;do nothing&lt;/SPAN&gt;
        &lt;SPAN&gt;Else&lt;/SPAN&gt;
            &lt;SPAN&gt;oListGauge&lt;/SPAN&gt;&lt;SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN&gt;Add&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;oValGauge&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;
            &lt;SPAN&gt;oListThick&lt;/SPAN&gt;&lt;SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN&gt;Add&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;sValThick&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;
            &lt;SPAN&gt;oListHolder&lt;/SPAN&gt; &lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;oListHolder&lt;/SPAN&gt; &lt;SPAN&gt;&amp;amp;&lt;/SPAN&gt; &lt;SPAN&gt;sValThick&lt;/SPAN&gt; &lt;SPAN&gt;&amp;amp;&lt;/SPAN&gt; &lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt; // &lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt; &lt;SPAN&gt;&amp;amp;&lt;/SPAN&gt; &lt;SPAN&gt;oValGauge&lt;/SPAN&gt; &lt;SPAN&gt;&amp;amp;&lt;/SPAN&gt; &lt;SPAN&gt;vbLf&lt;/SPAN&gt;
        &lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;
&lt;SPAN&gt;Next&lt;/SPAN&gt;

&lt;SPAN&gt;'&lt;/SPAN&gt;&lt;SPAN&gt;MessageBox.Show(oListHolder, "List of Gauge &amp;amp; Thickness")&lt;/SPAN&gt;

&lt;SPAN&gt;MultiValue&lt;/SPAN&gt;&lt;SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN&gt;List&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;GAUGE&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt; &lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;oListGauge&lt;/SPAN&gt;
&lt;SPAN&gt;MultiValue&lt;/SPAN&gt;&lt;SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN&gt;List&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;THICKNESS_GAUGE&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt; &lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;oListThick&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;Fails at first instance of GoExcel.CellValue&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 16 Jan 2017 16:02:25 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6808351#M69349</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-01-16T16:02:25Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6809053#M69358</link>
      <description>&lt;P&gt;Try this in a rule and report back to how it runs:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;AddReference "Microsoft.Office.Interop.Excel" 'To use excel

Sub Main()

	oExcelPath = "G:\FSH_Engineering\ENGINEERING DRAWINGS\_DRAWING TEMPLATES\_INVENTOR\_START PARTS\UTILITY\GAUGE.xlsx"
	oSheetName = "Sheet1" 
	
	Dim xlApp As Microsoft.Office.Interop.Excel.Application 
	xlApp = GetObject("", "Excel.Application") 
	Dim xlwb As Microsoft.Office.Interop.Excel.WorkBook 
	xlwb = xlApp.Workbooks.Open(oExcelPath)
	Dim xlws As Microsoft.Office.Interop.Excel.Worksheet
	xlws = xlwb.Worksheets(oSheetName)
	
	MsgBox("Cell A1 is: " &amp;amp; xlws.Cells(1, "A").Value)
	
	xlwb.Close(SaveChanges:= False)
	xlApp.Quit
	xlApp = Nothing

End Sub&amp;nbsp;&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 16 Jan 2017 20:54:53 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6809053#M69358</guid>
      <dc:creator>MechMachineMan</dc:creator>
      <dc:date>2017-01-16T20:54:53Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6809984#M69361</link>
      <description>&lt;P&gt;Hey, it crashed due to an error&amp;nbsp;in loading of the Excell interop library, so I don't think adding the reference manually will resolve this.&lt;/P&gt;
&lt;P&gt;However you can still use Excel, even with&amp;nbsp;broken library connection (thanks to the late binding). It's similar to what&amp;nbsp;&lt;A class="pop-name" href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/2511355" target="_blank"&gt;MechMachineMan&lt;/A&gt;&amp;nbsp;suggested, except you won't cast the object to Excel types, but use them as objects.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;Sub Main()
	Dim oExcelPath As String = "G:\FSH_Engineering\ENGINEERING DRAWINGS\_DRAWING TEMPLATES\_INVENTOR\_START PARTS\UTILITY\GAUGE.xlsx"
	
	Dim oExcel As Object = CreateObject("Excel.Application")
	oExcel.Visible = False
	oExcel.DisplayAlerts = False
	Dim oWB As Object = oExcel.Workbooks.Open(oExcelPath)
	Dim oWS As Object = oWB.Sheets(1) &lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;'Sheet 1&lt;/STRONG&gt;&lt;/FONT&gt;
	oWS.Activate()

	&lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;'In this sample, when you're getting a cell, the row is first&lt;/STRONG&gt;&lt;/FONT&gt;
	MsgBox("Cell A2 is: " &amp;amp; oWS.Cells(2, 1).Value)
	
	'oWB.Save() &lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;'Use this to save it&lt;/STRONG&gt;&lt;/FONT&gt;
	oWB.Close (True)
	oExcel.Quit
	oExcel = Nothing
End Sub &lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 17 Jan 2017 10:11:20 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6809984#M69361</guid>
      <dc:creator>Owner2229</dc:creator>
      <dc:date>2017-01-17T10:11:20Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6811614#M69386</link>
      <description>&lt;P&gt;This definitely worked. If you have time, I am very curious as to why GoExcel didn't work and casting it as an object did. Thanks!&lt;/P&gt;</description>
      <pubDate>Tue, 17 Jan 2017 20:13:05 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6811614#M69386</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-01-17T20:13:05Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6811686#M69390</link>
      <description>&lt;P&gt;"GoExcel" just like "Microsoft.Office.Interop" uses the Office library file (DLL) to control Excel.&lt;/P&gt;
&lt;P&gt;It looks into registers and gets the DLL location from there. Sometimes it may happen (somehow) the location stored in registers becomes invalid.&lt;/P&gt;
&lt;P&gt;It might be due to poor un/instalation of the program or just some kind of error.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;The sample I gave you "CreateObject("Excel.Application")" is also using registers, but it's not looking for the Interop library but rather directly at the registered Excel application. If you'll instal multiple Office versions the last runned one will be the one that will open using this code.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 17 Jan 2017 20:41:52 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6811686#M69390</guid>
      <dc:creator>Owner2229</dc:creator>
      <dc:date>2017-01-17T20:41:52Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6812199#M69394</link>
      <description>&lt;P&gt;Interesting, thanks for the quick responses!&lt;/P&gt;</description>
      <pubDate>Wed, 18 Jan 2017 00:45:57 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6812199#M69394</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-01-18T00:45:57Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6812389#M69395</link>
      <description>&lt;P&gt;I recall that after exhausting all other effort, I solved the problem by re-install windows 7 prof, then Office 2013 prof then Inventor 2016 prof for that particular machine.&amp;nbsp; I recommend to keep software in your machine as lean as possible and do not install two versions of any of these program.&amp;nbsp; Too many add on will complicate the communication between these 3 software.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Wed, 18 Jan 2017 04:00:31 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/6812389#M69395</guid>
      <dc:creator>liminma8458</dc:creator>
      <dc:date>2017-01-18T04:00:31Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/7989233#M84125</link>
      <description>&lt;P&gt;I Have a very similar problem with some ilogic that is used to refresh values from an Excel list.&lt;/P&gt;&lt;P&gt;Anyone know what command is needed to replace the GoExcel statement?&lt;/P&gt;&lt;P&gt;This is the code in question.&lt;/P&gt;&lt;P&gt;SyntaxEditor Code Snippet&lt;/P&gt;&lt;PRE&gt;&lt;SPAN style="color: #800080;"&gt;MultiValue&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;List&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"myFinishExt"&lt;/SPAN&gt;) = &lt;SPAN style="color: #800080;"&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;CellValues&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"I:\Templates 2018\myFinishExt.xlsx"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"Sheet1"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"A2"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"A100"&lt;/SPAN&gt;)
&lt;SPAN style="color: #800080;"&gt;MultiValue&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;List&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"myFinishInt"&lt;/SPAN&gt;) = &lt;SPAN style="color: #800080;"&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;CellValues&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"I:\Templates 2018\myFinishInt.xlsx"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"Sheet1"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"A2"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"A100"&lt;/SPAN&gt;)
&lt;SPAN style="color: #800080;"&gt;MultiValue&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;List&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"myMaterial"&lt;/SPAN&gt;) = &lt;SPAN style="color: #800080;"&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;CellValues&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"I:\Templates 2018\myMaterial.xlsx"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"Sheet1"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"A2"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"A100"&lt;/SPAN&gt;)&lt;/PRE&gt;&lt;P&gt;I've used the solution from &lt;SPAN class="UserName lia-user-name lia-user-rank-Advisor lia-component-message-view-widget-author-username"&gt;&lt;A href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/3072914" target="_self"&gt;&lt;SPAN class=""&gt;Owner2229&lt;BR /&gt;&lt;/SPAN&gt;&lt;/A&gt;&lt;SPAN class=""&gt;which successfully calls Excel, but I'm not sure what to use in place of GoExcel. to get my values?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN style="color: #ff0000;"&gt;Sub&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;Main&lt;/SPAN&gt;()
	&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;oExcelPath&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;String&lt;/SPAN&gt; = &lt;SPAN style="color: #008080;"&gt;"I:\Templates 2018\myFinishExt.xlsx"&lt;/SPAN&gt;
	
	&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;oExcel&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;Object&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;CreateObject&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Excel.Application"&lt;/SPAN&gt;)
	&lt;SPAN style="color: #800000;"&gt;oExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Visible&lt;/SPAN&gt; = &lt;SPAN style="color: #ff0000;"&gt;False&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;oExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;DisplayAlerts&lt;/SPAN&gt; = &lt;SPAN style="color: #ff0000;"&gt;False&lt;/SPAN&gt;
	&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;oWB&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;Object&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;oExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Workbooks&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Open&lt;/SPAN&gt;(&lt;SPAN style="color: #800000;"&gt;oExcelPath&lt;/SPAN&gt;)
	&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;oWS&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;Object&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;oWB&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Sheets&lt;/SPAN&gt;(1) &lt;SPAN style="color: #808080;"&gt;'Sheet 1&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;oWS&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Activate&lt;/SPAN&gt;()

	&lt;SPAN style="color: #808080;"&gt;'In this sample, when you're getting a cell, the row is first&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;MsgBox&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Cell A2 is: "&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;oWS&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Cells&lt;/SPAN&gt;(2, 1).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt;)
	
	&lt;SPAN style="color: #808080;"&gt;'oWB.Save() 'Use this to save it&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;oWB&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Close&lt;/SPAN&gt; (&lt;SPAN style="color: #ff0000;"&gt;True&lt;/SPAN&gt;)
	&lt;SPAN style="color: #800000;"&gt;oExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Quit&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;oExcel&lt;/SPAN&gt; = &lt;SPAN style="color: #ff0000;"&gt;Nothing&lt;/SPAN&gt;
&lt;SPAN style="color: #ff0000;"&gt;End&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;Sub&lt;/SPAN&gt; &lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 09 May 2018 07:31:52 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/7989233#M84125</guid>
      <dc:creator>andy-axium</dc:creator>
      <dc:date>2018-05-09T07:31:52Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/8003466#M84347</link>
      <description>&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can use a function like this:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Sub Main()
	MultiValue.List("myFinishExt") = ReadValues("I:\Templates 2018\myFinishExt.xlsx", 1, 1, 2, 100)
	MultiValue.List("myFinishInt") = ReadValues("I:\Templates 2018\myFinishInt.xlsx", 1, 1, 2, 100)
	MultiValue.List("myMaterial") = ReadValues("I:\Templates 2018\myMaterial.xlsx", 1, 1, 2, 100)
End Sub

Private Function ReadValues(sExcelPath As String, Sheet As Integer, Column As Integer, StartRow As Integer, EndRow As Integer) As String()
	Dim R() As String
	Try
		Dim Range As Integer = Abs(EndRow - StartRow)
		Redim R(Range)
		Dim oExcel As Object = CreateObject("Excel.Application")
		oExcel.Visible = False
		oExcel.DisplayAlerts = False
		Dim oWB As Object = oExcel.Workbooks.Open(sExcelPath)
		Dim oWS As Object = oWB.Sheets(Sheet)
		oWS.Activate()
		Dim j As Integer = 0
		For i As Integer = StartRow To EndRow
			R(j) = oWS.Cells(i, Column).Value
			j += 1
		Next
		oWB.Close (True)
		oExcel.Quit()
		oExcel = Nothing
	Catch
	End Try
	Return R
End Function&lt;/PRE&gt;</description>
      <pubDate>Tue, 15 May 2018 16:11:00 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/8003466#M84347</guid>
      <dc:creator>Owner2229</dc:creator>
      <dc:date>2018-05-15T16:11:00Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/8020808#M84655</link>
      <description>&lt;P&gt;Thanks will give this a try&lt;/P&gt;</description>
      <pubDate>Wed, 23 May 2018 13:22:42 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/8020808#M84655</guid>
      <dc:creator>andy-axium</dc:creator>
      <dc:date>2018-05-23T13:22:42Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/8037519#M84894</link>
      <description>&lt;P&gt;Owner2229, thanks for your code however when running it errors with "Object reference not set to an instance of an object"&lt;/P&gt;&lt;P&gt;By adding messagebox comments it seems that the code run until the Catch statement?&lt;/P&gt;&lt;P&gt;Further assistance would be greatly appreciated&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 31 May 2018 09:27:47 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/8037519#M84894</guid>
      <dc:creator>andy-axium</dc:creator>
      <dc:date>2018-05-31T09:27:47Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/8049912#M85132</link>
      <description>&lt;P&gt;Just an update on the iLogic GoExcel error, after AutoDesk Support remoted on to my m/c with TeamViewer, the ilogic error was cured!&lt;/P&gt;</description>
      <pubDate>Wed, 06 Jun 2018 09:27:51 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/8049912#M85132</guid>
      <dc:creator>andy-axium</dc:creator>
      <dc:date>2018-06-06T09:27:51Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/11113836#M136942</link>
      <description>&lt;P&gt;Andy, what did they do to fix it? I am trying to fix this same issue...&lt;/P&gt;&lt;P&gt;I tried this but now when I try to open the file to edit it, excel just blinks on and off and I cannot do anything with the file:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oExcelPath&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;"\\server1\Inventor\Job\Create Projects.xlsx"&lt;/SPAN&gt;
	
	&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oExcel&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Object&lt;/SPAN&gt; = &lt;SPAN&gt;CreateObject&lt;/SPAN&gt;(&lt;SPAN&gt;"Excel.Application"&lt;/SPAN&gt;)
	&lt;SPAN&gt;oExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Visible&lt;/SPAN&gt; = &lt;SPAN&gt;False&lt;/SPAN&gt;
	&lt;SPAN&gt;oExcel&lt;/SPAN&gt;.&lt;SPAN&gt;DisplayAlerts&lt;/SPAN&gt; = &lt;SPAN&gt;False&lt;/SPAN&gt;
	&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oWB&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Object&lt;/SPAN&gt; = &lt;SPAN&gt;oExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Workbooks&lt;/SPAN&gt;.&lt;SPAN&gt;Open&lt;/SPAN&gt;(&lt;SPAN&gt;oExcelPath&lt;/SPAN&gt;)
	&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oWS&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Object&lt;/SPAN&gt; = &lt;SPAN&gt;oWB&lt;/SPAN&gt;.&lt;SPAN&gt;Sheets&lt;/SPAN&gt;(1) &lt;SPAN&gt;'Sheet 1&lt;/SPAN&gt;
	&lt;SPAN&gt;oWS&lt;/SPAN&gt;.&lt;SPAN&gt;Activate&lt;/SPAN&gt;()

	&lt;SPAN&gt;'In this sample, when you're getting a cell, the row is first&lt;/SPAN&gt;
	&lt;SPAN&gt;MsgBox&lt;/SPAN&gt;(&lt;SPAN&gt;"Cell A2 is: "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;oWS&lt;/SPAN&gt;.&lt;SPAN&gt;Cells&lt;/SPAN&gt;(2, 1).&lt;SPAN&gt;Value&lt;/SPAN&gt;)

&lt;SPAN&gt;'look at the rows A2 thru A50, adjust as needed&lt;/SPAN&gt;
&lt;SPAN&gt;'note blank rows are ok&lt;/SPAN&gt;
&lt;SPAN&gt;'Dim oList As New ArrayList&lt;/SPAN&gt;
&lt;SPAN&gt;'oList = oWS.Cells(2, 1).Value&lt;/SPAN&gt;

&lt;SPAN&gt;'' Set a reference to the DesignProjectManager object.&lt;/SPAN&gt;
&lt;SPAN&gt;'Dim oDesignProjectMgr As DesignProjectManager&lt;/SPAN&gt;
&lt;SPAN&gt;'oDesignProjectMgr = ThisApplication.DesignProjectManager&lt;/SPAN&gt;
&lt;SPAN&gt;'Dim oProject As DesignProject&lt;/SPAN&gt;

&lt;SPAN&gt;'For Each oNumber In oList&lt;/SPAN&gt;
&lt;SPAN&gt;'	' Create a new single user project	&lt;/SPAN&gt;
&lt;SPAN&gt;'	oProject = oDesignProjectMgr.DesignProjects.Add(kSingleUserMode, _&lt;/SPAN&gt;
&lt;SPAN&gt;'		oNumber, oPath &amp;amp; oNumber &amp;amp; "\")&lt;/SPAN&gt;
&lt;SPAN&gt;'Next&lt;/SPAN&gt;

	&lt;SPAN&gt;oWB&lt;/SPAN&gt;.&lt;SPAN&gt;Close&lt;/SPAN&gt; (&lt;SPAN&gt;True&lt;/SPAN&gt;)
	&lt;SPAN&gt;oExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Quit&lt;/SPAN&gt;
	&lt;SPAN&gt;oExcel&lt;/SPAN&gt; = &lt;SPAN&gt;Nothing&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 19 Apr 2022 11:56:08 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/11113836#M136942</guid>
      <dc:creator>chrisw01a</dc:creator>
      <dc:date>2022-04-19T11:56:08Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/11114005#M136947</link>
      <description>Have you verified the code works with .visible and .displayalerts both set to true?</description>
      <pubDate>Tue, 19 Apr 2022 13:11:08 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/11114005#M136947</guid>
      <dc:creator>MechMachineMan</dc:creator>
      <dc:date>2022-04-19T13:11:08Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/11116773#M137001</link>
      <description>&lt;P&gt;It does work but it still does the same thing. Seems like it is locking the file and not letting go of it or something.&lt;/P&gt;</description>
      <pubDate>Wed, 20 Apr 2022 13:51:46 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/11116773#M137001</guid>
      <dc:creator>chrisw01a</dc:creator>
      <dc:date>2022-04-20T13:51:46Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/11116979#M137002</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/552098"&gt;@chrisw01a&lt;/a&gt;,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;You might check the &lt;STRONG&gt;Task Manager&lt;/STRONG&gt; ( ctrl + alt + delete) &amp;gt; &lt;STRONG&gt;Details&lt;/STRONG&gt; tab, and see if you see a bunch of &lt;STRONG&gt;EXCEL.EXE&lt;/STRONG&gt; tasks listed. If so kill them.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Often when I'm working on something like this, as I hit errors in the iLogic testing it abandons invisible Excel files and leaves them open because the code errors out before being able to close them. Really, a proper error handler to catch the errors and close the file would be best.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;In any case, I think I've seen the behavior you mentioned when the file is open invisibly in the background, but I can't recall for sure. It's something to rule out though.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I hope this helps.&lt;BR /&gt;Best of luck to you in all of your Inventor pursuits,&lt;BR /&gt;Curtis&lt;BR /&gt;&lt;A href="http://inventortrenches.blogspot.com" target="_blank"&gt;http://inventortrenches.blogspot.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 20 Apr 2022 15:14:16 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/11116979#M137002</guid>
      <dc:creator>Curtis_Waguespack</dc:creator>
      <dc:date>2022-04-20T15:14:16Z</dc:date>
    </item>
    <item>
      <title>Re: Ilogic fails to talk to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/11117580#M137016</link>
      <description>You were correct. There were a bunch of Excels running. I'll try closing the file during the "catch" operation and see if that will solve it when an error is encountered.&lt;BR /&gt;</description>
      <pubDate>Wed, 20 Apr 2022 19:15:26 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-fails-to-talk-to-excel/m-p/11117580#M137016</guid>
      <dc:creator>chrisw01a</dc:creator>
      <dc:date>2022-04-20T19:15:26Z</dc:date>
    </item>
  </channel>
</rss>

