<?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 and excel issue in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9265068#M104810</link>
    <description>&lt;P&gt;It seems to be closed alright, none error appears.&lt;/P&gt;&lt;P&gt;I think I have solved the problem by restarting the PC after closing the excel in the task manager, at least for now.&lt;/P&gt;&lt;P&gt;Thanks for the quickly answer &lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@B4D44A73814D7FC0D950DEDFACB97081/emoticons/1f642.png" alt=":slightly_smiling_face:" title=":slightly_smiling_face:" /&gt;&lt;/P&gt;</description>
    <pubDate>Tue, 21 Jan 2020 17:50:22 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2020-01-21T17:50:22Z</dc:date>
    <item>
      <title>ilogic and excel issue</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9022040#M101214</link>
      <description>&lt;P&gt;when running some ilogic script that references an external excel sheet to read/write data, I keep getting "Belt Data.xlsx is already open" error.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have done everything from add goexcel.save / close at the end of the rules,&amp;nbsp; running silent operations, etc.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am at my wits end.&amp;nbsp; Is this an inventor issue? (If so, how do I fix it)&lt;/P&gt;&lt;P&gt;Is this an excel issue?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Arghh please help.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am attaching the part file and excel file to help&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 12 Sep 2019 17:42:07 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9022040#M101214</guid>
      <dc:creator>asmenut</dc:creator>
      <dc:date>2019-09-12T17:42:07Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic and excel issue</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9029304#M101326</link>
      <description>&lt;P&gt;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/3064"&gt;@asmenut&lt;/a&gt;,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Try below changes in iLogic code.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;ThisApplication.SilentOperation = True
'GoExcel.Open("M:\0700 Engineering\0770 DOCUMENTS\Excel Files\Belt Data.xlsx", "Belt_Data")

'Set Belt Series Multi-value list
MultiValue.List("BSeries") = GoExcel.CellValues("C:\Users\t_gc\Downloads\Belt Data.xlsx", "Belt_Data", "B4", "b147")

'Series = Parameter("BSeries")
rangeArray = GoExcel.NamedRangeValue("BS_" &amp;amp; BSeries)

'define and set Series Style list based on Belt Series
Dim oList As New ArrayList

	'Check if rangeArray is an array or a Single Row
	If IsArray(rangeArray)
		
		'Count the number of rows in array
		Dim oRowCount As Integer
			oRowCount = rangeArray.GetLength(0)

		'Populate arraylist 
		Dim oRowIndex As Integer
			For oRowIndex = 1 To oRowCount
				
				oList.Add(rangeArray(oRowIndex, 1))
			Next
		'Populate MultiValue Parameter
		MultiValue.List("BStyle") = oList

	Else
		Series_val = Parameter("BSeries")
	'	Style_Val = Parameter("BStyle")
		
		GoExcel.TitleRow = 3
		i = GoExcel.FindRow("C:\Users\t_gc\Downloads\Belt Data.xlsx", "Belt_Data", "SERIES", "=", Series_val)
		b = GoExcel.CurrentRowValue("SERIES")
		MessageBox.Show(b)
		'Parameter("BStyle")=goExcel.CurrentRowValue("STYLE")
	End If	
	

'GoExcel.Open("M:\0700 Engineering\0770 DOCUMENTS\Excel Files\Belt Data.xlsx", "Sprocket_Data")

'Set Spr_PD Multi-value list

PD= Parameter("Spr_PD")
SP_rangeArray = GoExcel.NamedRangeValue("SP_" &amp;amp; Parameter("BSeries"))

'define and set Sprocket PD list based on Belt Series
Dim sList As New ArrayList

		
		'Count the number of rows in array
		Dim sRowCount As Integer
			sRowCount = SP_rangeArray.GetLength(0)

		'Populate arraylist 
		Dim sRowIndex As Integer
			For sRowIndex = 1 To sRowCount
				sList.Add(SP_rangeArray(sRowIndex, 1))
			Next
				'Populate MultiValue Parameter
			MultiValue.List("Spr_PD") = sList
			

&lt;FONT color="#FF0000"&gt;Call GoExcel.Close ()&lt;/FONT&gt;
iLogicVb.UpdateWhenDone = True	&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thanks and regards,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 17 Sep 2019 09:03:40 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9029304#M101326</guid>
      <dc:creator>chandra.shekar.g</dc:creator>
      <dc:date>2019-09-17T09:03:40Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic and excel issue</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9029677#M101333</link>
      <description>&lt;P&gt;Thank you Chandra.&amp;nbsp; Works alot better, but it still says that the "Belt Data.xlsx is already ope. Reopening will cause any changes you made to be discarded. Do you want to reopen Belt Data.xlsx.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Could this be an excel issue, since I am using the "Indirect" Function in the spreadsheet?&lt;/P&gt;</description>
      <pubDate>Tue, 17 Sep 2019 11:49:57 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9029677#M101333</guid>
      <dc:creator>asmenut</dc:creator>
      <dc:date>2019-09-17T11:49:57Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic and excel issue</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9031765#M101360</link>
      <description>&lt;P&gt;Many times the problem is that when you write and test you programm, you come past the open excel part, but not past the close part, so the excel files is opened in the background.&lt;/P&gt;&lt;P&gt;so the second time you run the program, you get the problem that the file is already open&lt;/P&gt;&lt;P&gt;look in the windows task manager, than close all excel processes, then try again.&lt;/P&gt;&lt;P&gt;(if you change the excel with your code, you have to save and than close it)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 18 Sep 2019 07:41:07 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9031765#M101360</guid>
      <dc:creator>HermJan.Otterman</dc:creator>
      <dc:date>2019-09-18T07:41:07Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic and excel issue</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9259271#M104723</link>
      <description>&lt;P&gt;I think something similar is happening to me. I have some rules to modify one excel sheet, the code is different to the one show above but i believe that the error appears due to the excel is also open in the background. I have tried to close it in the windows task manager but it is still opened. Any other idea to try? Thanks.&lt;/P&gt;</description>
      <pubDate>Sat, 18 Jan 2020 18:35:46 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9259271#M104723</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2020-01-18T18:35:46Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic and excel issue</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9261082#M104746</link>
      <description>&lt;P&gt;when you try to close the excel proces in the task mnger, do you get an error?&lt;/P&gt;&lt;P&gt;when you retart you PC, and after it i rebooted look in the task manager, before you open any other program, is the excel proces started?&lt;/P&gt;&lt;P&gt;maybe something else than your program is using excel?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 20 Jan 2020 08:57:33 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9261082#M104746</guid>
      <dc:creator>HermJan.Otterman</dc:creator>
      <dc:date>2020-01-20T08:57:33Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic and excel issue</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9265068#M104810</link>
      <description>&lt;P&gt;It seems to be closed alright, none error appears.&lt;/P&gt;&lt;P&gt;I think I have solved the problem by restarting the PC after closing the excel in the task manager, at least for now.&lt;/P&gt;&lt;P&gt;Thanks for the quickly answer &lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@B4D44A73814D7FC0D950DEDFACB97081/emoticons/1f642.png" alt=":slightly_smiling_face:" title=":slightly_smiling_face:" /&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 21 Jan 2020 17:50:22 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-and-excel-issue/m-p/9265068#M104810</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2020-01-21T17:50:22Z</dc:date>
    </item>
  </channel>
</rss>

