<?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 help to create multple MultiValue.List from an Excel in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6031646#M61586</link>
    <description>&lt;P&gt;hello?!?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;can anyone offer any help here?&lt;/P&gt;</description>
    <pubDate>Tue, 09 Feb 2016 18:30:31 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2016-02-09T18:30:31Z</dc:date>
    <item>
      <title>iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6027426#M61534</link>
      <description>&lt;P&gt;please help! i'm stuck &lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@F462EEC827775DA92CB03B7FC147D389/emoticons/1f61e.png" alt=":disappointed_face:" title=":disappointed_face:" /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;here is a simplified example of what i am trying to do...&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;IMG src="https://forums.autodesk.com/t5/image/serverpage/image-id/216496iA4C5DC5EB56CDB89/image-size/original?v=mpbl-1&amp;amp;px=-1" alt="Excel_test.JPG" title="Excel_test.JPG" border="0" /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;i trying to create multiple MultiValue.List from Excel, and here is a small snippet that i know works...&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;MultiValue.SetList("SIZE", "SIZE-AA", "SIZE-BB", "SIZE-CC")

If SIZE = "SIZE-AA" Then
	GoExcel.TitleRow = 2
	MultiValue.List("MODEL") = GoExcel.CellValues("filename.xls", "Sheet1", "A3", "A5")
ElseIf SIZE = "SIZE-BB" Then
	GoExcel.TitleRow = 7
	MultiValue.List("MODEL") = GoExcel.CellValues("filename.xls", "Sheet1", "A8", "A10")
ElseIf SIZE = "SIZE-CC" Then
	GoExcel.TitleRow = 12
	MultiValue.List("MODEL") = GoExcel.CellValues("filename.xls", "Sheet1", "A13", "A15")
End If&lt;/PRE&gt;&lt;P&gt;so now, what i would like to do is create another MultiValue.List from the first MultiValue.List.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;for example, if i select "SIZE-AA" from my "SIZE" multi-list (SIZE-AA, SIZE-BB, SIZE-CC), my next list from "MODEL" would give me "AA100, AA110, AA210", then my next list for eg. "AA110" would be "10, 20, 30,40".&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;can this even be done?&lt;/P&gt;&lt;P&gt;thanks&lt;/P&gt;</description>
      <pubDate>Sat, 06 Feb 2016 17:12:15 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6027426#M61534</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-02-06T17:12:15Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6031646#M61586</link>
      <description>&lt;P&gt;hello?!?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;can anyone offer any help here?&lt;/P&gt;</description>
      <pubDate>Tue, 09 Feb 2016 18:30:31 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6031646#M61586</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-02-09T18:30:31Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6032484#M61596</link>
      <description>&lt;P&gt;Hi, how about something like this?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Dim oRow As Integer
Select Case Parameter("MODEL")
    Case "AA100": oRow = 3
    Case "AA110": oRow = 4
    Case "AA120": oRow = 5
    Case "BB100": oRow = 8
    Case "BB110": oRow = 9
    Case "BB120": oRow = 10
    'And so on for C...
End Select

MultiValue.List("SIZE-VALUES") = GoExcel.CellValues("filename.xls", "Sheet1", "B" &amp;amp; oRow, "E" &amp;amp; oRow)&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;BTW. I wouldn't do this task this way at all. I'll load all the values in first place and then work with them (because working&amp;nbsp;with an excel table takes quite some time).&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Maybe something like this:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Sub Main()&lt;BR /&gt;    MultiValue.SetList("SIZE", "SIZE-AA", "SIZE-BB", "SIZE-CC")&lt;BR /&gt;    Dim Row As Integer&lt;BR /&gt;    Dim oMyValues As Variant&lt;BR /&gt;    GoExcel.Open("filename.xls", "Sheet1")&lt;BR /&gt;    Row = 1
    For j = 3&amp;nbsp;To 5 &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set the rows for AA... values&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;        GetValues(oMyValues, Row, j)&lt;BR /&gt;        Row = Row + 1&lt;BR /&gt;    Next&lt;BR /&gt;    For j = 8&amp;nbsp;To 10 &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set the rows for BB... values&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;        GetValues(oMyValues, Row, j)&lt;BR /&gt;        Row = Row + 1&lt;BR /&gt;    Next&lt;BR /&gt;    For j = 13&amp;nbsp;To 15 &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set the rows for CC... values&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;        GetValues(oMyValues, Row, j)&lt;BR /&gt;        Row = Row + 1&lt;BR /&gt;    Next&lt;BR /&gt;    GoExcel.Close&lt;BR /&gt;    Dim oModel As String&lt;BR /&gt;    oModel = Parameter("SIZE")&lt;BR /&gt;&lt;SPAN&gt;    Dim&lt;/SPAN&gt; &lt;SPAN&gt;MyArrayList&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;ArrayList&lt;/SPAN&gt;&lt;BR /&gt;    For i = 1 To UBound(oMyValues, 1)&lt;BR /&gt;        If oMyValues(i, 1) = oModel Then&lt;BR /&gt;            MyArrayList.Add(oMyValues(i, 2))&lt;BR /&gt;            MyArrayList.Add(oMyValues(i, 3))&lt;BR /&gt;            MyArrayList.Add(oMyValues(i, 4))&lt;BR /&gt;            MyArrayList.Add(oMyValues(i, 5))&lt;BR /&gt;        End If&lt;BR /&gt;    Next&lt;BR /&gt;    MultiValue.List("SIZE-VALUES") = MyArrayList&lt;BR /&gt;End Sub&lt;BR /&gt;&lt;BR /&gt;Private Sub GetValues(oMyValues As Variant, Row As Integer, j As Integer)&lt;BR /&gt;    oMyValues(Row, 1) =&amp;nbsp;GoExcel.CellValue("A" &amp;amp; j)&lt;BR /&gt;    oMyValues(Row, 2) =&amp;nbsp;GoExcel.CellValue("B" &amp;amp; j)&lt;BR /&gt;    oMyValues(Row, 3) =&amp;nbsp;GoExcel.CellValue("C" &amp;amp; j)&lt;BR /&gt;    oMyValues(Row, 4) =&amp;nbsp;GoExcel.CellValue("D" &amp;amp; j)&lt;BR /&gt;    oMyValues(Row, 5) =&amp;nbsp;GoExcel.CellValue("E" &amp;amp; j)&lt;BR /&gt;End Usb&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 10 Feb 2016 07:30:37 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6032484#M61596</guid>
      <dc:creator>Owner2229</dc:creator>
      <dc:date>2016-02-10T07:30:37Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6033072#M61614</link>
      <description>&lt;P&gt;thank you so much for replying &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;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;but i guess i should have stated that i'm using INV2013 but have plans of upgrading to INV2016 in the very near future&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;i'm trying your code but i'm getting an error with&lt;/P&gt;&lt;PRE&gt;oMyValues As Variant&lt;/PRE&gt;&lt;P&gt;Error on Line 4 : 'Variant' is no longer a supported type; use the 'Object' type instead.&lt;BR /&gt;Error on Line 34 : 'Variant' is no longer a supported type; use the 'Object' type instead.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;my knowledge of iLogic is a little more than basic (and i am not a programmer by any means) but i have learned and used lots from this forum&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;my end goal for this snippet of code is to generate a Model number based on the multiple selections given.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;thanks again for your help&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;-Leonard&lt;/P&gt;</description>
      <pubDate>Wed, 10 Feb 2016 13:51:02 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6033072#M61614</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-02-10T13:51:02Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6033141#M61616</link>
      <description>&lt;P&gt;Hi, as I see now I had some errors in the code. This one below should be working. You muss have the folowing parameters in model:&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;SIZE&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;SIZE_VALUES&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Sub Main()
    MultiValue.SetList("SIZE", "SIZE-AA", "SIZE-BB", "SIZE-CC")
    Dim Row As Integer
    Dim oMyValues(9, 5) As Object &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set the range for values (9 rows, 5 columns)&lt;/STRONG&gt;&lt;/FONT&gt;
    GoExcel.Open("filename.xls", "Sheet1")
    Row = 1
    For j = 3 To 5 &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set the rows for AA... values&lt;/STRONG&gt;&lt;/FONT&gt;
        GetValues(oMyValues, Row, j)
        Row = Row + 1
    Next
    For j = 8 To 10 &lt;STRONG&gt;&lt;FONT color="#FF0000"&gt;' Set the rows for BB... values&lt;/FONT&gt;&lt;/STRONG&gt;
        GetValues(oMyValues, Row, j)
        Row = Row + 1
    Next
    For j = 13 To 15 &lt;STRONG&gt;&lt;FONT color="#FF0000"&gt;' Set the rows for CC... values&lt;/FONT&gt;&lt;/STRONG&gt;
        GetValues(oMyValues, Row, j)
        Row = Row + 1
    Next
    GoExcel.Close
    Dim oModel As String
    oModel = Parameter("SIZE")
    Dim MyArrayList As New ArrayList
    For i = 1 To UBound(oMyValues, 1)
	If oMyValues(i, 1) = oModel Then
	    MyArrayList.Add(oMyValues(i, 2))
            MyArrayList.Add(oMyValues(i, 3))
            MyArrayList.Add(oMyValues(i, 4))
            MyArrayList.Add(oMyValues(i, 5))
        End If
    Next
    MultiValue.List("SIZE_VALUES") = MyArrayList
End Sub

Private Sub GetValues(oMyValues As Object, Row As Integer, j As Integer)
    oMyValues(Row, 1) = GoExcel.CellValue("A" &amp;amp; j)
    oMyValues(Row, 2) = GoExcel.CellValue("B" &amp;amp; j)
    oMyValues(Row, 3) = GoExcel.CellValue("C" &amp;amp; j)
    oMyValues(Row, 4) = GoExcel.CellValue("D" &amp;amp; j)
    oMyValues(Row, 5) = GoExcel.CellValue("E" &amp;amp; j)
End Sub&amp;nbsp;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 10 Feb 2016 14:24:26 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6033141#M61616</guid>
      <dc:creator>Owner2229</dc:creator>
      <dc:date>2016-02-10T14:24:26Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6033218#M61619</link>
      <description>&lt;P&gt;zero errors dialog boxes using your code but the parameter "SIZE_VALUES" doesn't show a multi-value list in the parameter list&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;also, what about the "Model" parameter that you had shown? should that be included in what you have shown?&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>Wed, 10 Feb 2016 14:57:43 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6033218#M61619</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-02-10T14:57:43Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6034710#M61641</link>
      <description>&lt;P&gt;Hi, you have to run it once, then go to parameters (or do it using another rule) and select an value for the "SIZE" parameter. Then run this rule again.&lt;/P&gt;&lt;P&gt;I have added parameter check so you don't need to care if the parameter is created or not. The parameter "MODEL" is not needed as all the values are now stored in the "oMyValues" object.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Sub Main()
    CheckParam("SIZE")&lt;BR /&gt;    MultiValue.SetList("SIZE", "SIZE-AA", "SIZE-BB", "SIZE-CC")
    Dim Row As Integer
    Dim oMyValues(&lt;STRONG&gt;&lt;FONT color="#FF0000"&gt;9, 5&lt;/FONT&gt;&lt;/STRONG&gt;) As Object &lt;STRONG&gt;&lt;FONT color="#FF0000"&gt;' Set the range for values (9 rows, 5 columns)&lt;/FONT&gt;&lt;/STRONG&gt;
    GoExcel.Open("&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;filename.xls&lt;/STRONG&gt;&lt;/FONT&gt;", "Sheet1")
    Row = 1
    For j = 3 To 5 &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set the rows for AA... values&lt;/STRONG&gt;&lt;/FONT&gt;
        GetValues(oMyValues, Row, j)
        Row = Row + 1
    Next
    For j = 8 To 10 &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set the rows for BB... values&lt;/STRONG&gt;&lt;/FONT&gt;
        GetValues(oMyValues, Row, j)
        Row = Row + 1
    Next
    For j = 13 To 15 &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set the rows for CC... values&lt;/STRONG&gt;&lt;/FONT&gt;
        GetValues(oMyValues, Row, j)
        Row = Row + 1
    Next
    GoExcel.Close
    Dim oModel As String
    oModel = Parameter("SIZE")
    Dim MyArrayList As New ArrayList
    For i = 1 To UBound(oMyValues, 1)
	If oMyValues(i, 1) = oModel Then
	    MyArrayList.Add(oMyValues(i, 2))
            MyArrayList.Add(oMyValues(i, 3))
            MyArrayList.Add(oMyValues(i, 4))
            MyArrayList.Add(oMyValues(i, 5))
        End If
    Next&lt;BR /&gt;    CheckParam("SIZE_VALUES")
    MultiValue.List("SIZE_VALUES") = MyArrayList
End Sub

Private Sub GetValues(oMyValues As Object, Row As Integer, j As Integer)
    oMyValues(Row, 1) = GoExcel.CellValue("A" &amp;amp; j)
    oMyValues(Row, 2) = GoExcel.CellValue("B" &amp;amp; j)
    oMyValues(Row, 3) = GoExcel.CellValue("C" &amp;amp; j)
    oMyValues(Row, 4) = GoExcel.CellValue("D" &amp;amp; j)
    oMyValues(Row, 5) = GoExcel.CellValue("E" &amp;amp; j)
End Sub

Private Sub CheckParam(oParaName As String)
   oParameters = ThisApplication.ActiveDocument.ComponentDefinition.Parameters.UserParameters
   Try
      Parameter(oParaName) = Parameter(oParaName)
   Catch
      oParameter = oParameters.AddByValue(oParaName, "", UnitsTypeEnum.kTextUnits)
   End Try
End Sub&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Here below is the rule to pick one of&amp;nbsp;the "SIZE" parameter values. Use the number to pick (first/second/...) value from the parameter list.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Try
    Parameter("SIZE") = Parameter("SIZE")&lt;BR /&gt;&lt;SPAN&gt;    Parameter&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;SIZE&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt; &lt;SPAN&gt;=&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;SIZE&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;&lt;SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN&gt;Item&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;1&lt;/STRONG&gt;&lt;/FONT&gt;&lt;SPAN&gt;)&lt;BR /&gt;&lt;/SPAN&gt;Catch
    MsgBox("The parameter 'SIZE' doesn't exist")
End Try&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 11 Feb 2016 06:07:13 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6034710#M61641</guid>
      <dc:creator>Owner2229</dc:creator>
      <dc:date>2016-02-11T06:07:13Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6037127#M61668</link>
      <description>&lt;P&gt;hey, i'm sorry for not replying soon, i got busy at work and couldn't look at this code&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;i also want to say thank you so much for your help here, i really do appreciate all your efforts&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;but i'm still running into issues here with some of this code. i've tried this in INV2013 and INV2016 and i'm getting the same errors&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;the 1st error is in the "MODEL" snippet:&amp;nbsp;Excel cell not found (bad cell address?): "B0"&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;and the 2nd error is in the main code snippet. the parameter "SIZE_VALUES" doesn't return the Multi-value list. the list is empty&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;and i do have one more small favor. for the benefit of myself and others here trying to learn iLogic, could you add more comments to the code so that i/we could understand what exactly is going on here&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;once again, thanks again for your help here &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;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 12 Feb 2016 14:16:45 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6037127#M61668</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-02-12T14:16:45Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6037236#M61675</link>
      <description>&lt;P&gt;Hi, the "MODEL" snipset is supposed to be placed after your original code, like this:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set the list of "SIZE" parameter&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;MultiValue.SetList("SIZE", "SIZE-AA", "SIZE-BB", "SIZE-CC")
&lt;BR /&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Determine the SIZE value&lt;/STRONG&gt;&lt;/FONT&gt;
If SIZE = "SIZE-AA" Then
	&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Load values from excel&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;        GoExcel.TitleRow = 2&lt;BR /&gt;        &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Fill the "MODEL" parameter with found values&lt;/STRONG&gt;&lt;/FONT&gt;
	MultiValue.List("MODEL") = GoExcel.CellValues("filename.xls", "Sheet1", "A3", "A5")
ElseIf SIZE = "SIZE-BB" Then
	GoExcel.TitleRow = 7
	MultiValue.List("MODEL") = GoExcel.CellValues("filename.xls", "Sheet1", "A8", "A10")
ElseIf SIZE = "SIZE-CC" Then
	GoExcel.TitleRow = 12
	MultiValue.List("MODEL") = GoExcel.CellValues("filename.xls", "Sheet1", "A13", "A15")
End If

Dim oRow As Integer&lt;BR /&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Pick the value from "MODEL" parameter&lt;/STRONG&gt;&lt;/FONT&gt;
Select Case Parameter("MODEL")
    &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set searched row, according to "MODEL" parameter value&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;    Case "AA100": oRow = 3
    Case "AA110": oRow = 4
    Case "AA120": oRow = 5
    Case "BB100": oRow = 8
    Case "BB110": oRow = 9
    Case "BB120": oRow = 10
    'And so on for C...
End Select
&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT color="#FF0000"&gt;' Fill the "SIZE-VALUES" parameter with vaues from the excel table,&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT color="#FF0000"&gt;' using the previously set "oRow" variable with combination of columns "B" and "E"&lt;/FONT&gt;&lt;/STRONG&gt;
MultiValue.List("SIZE-VALUES") = GoExcel.CellValues("filename.xls", "Sheet1", "B" &amp;amp; oRow, "E" &amp;amp; oRow)&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Here to the second snipset:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Sub Main()
    &lt;STRONG&gt;&lt;FONT color="#FF0000"&gt;' Check if the parameter "SIZE" does exist and has valid value. End this makro if not.&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;    If CheckParam("SIZE") = "" Then
        MultiValue.SetList("SIZE", "SIZE-AA", "SIZE-BB", "SIZE-CC")&lt;BR /&gt;        MsgBox("Please select value for SIZE parameter first.")&lt;BR /&gt;        Exit Sub&lt;BR /&gt;    End If&lt;BR /&gt;    Dim Row As Integer&lt;BR /&gt;    &lt;STRONG&gt;&lt;FONT color="#FF0000"&gt;' Create new object table to store the excel table in&lt;/FONT&gt;&lt;/STRONG&gt;
    Dim oMyValues(9, 5) As Object &lt;STRONG&gt;&lt;FONT color="#FF0000"&gt;' Set the range for values (9 rows, 5 columns)&lt;BR /&gt;&lt;/FONT&gt;&lt;/STRONG&gt;    &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Open excel document&lt;/STRONG&gt;&lt;/FONT&gt;
    GoExcel.Open("filename.xls", "Sheet1")
    Row = 1&lt;BR /&gt;    &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Load all values from the excel table&lt;/STRONG&gt;&lt;/FONT&gt;
    For j = 3 To 5 &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set the rows for AA... values&lt;/STRONG&gt;&lt;/FONT&gt;
        GetValues(oMyValues, Row, j)
        Row = Row + 1
    Next
    For j = 8 To 10 &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set the rows for BB... values&lt;/STRONG&gt;&lt;/FONT&gt;
        GetValues(oMyValues, Row, j)
        Row = Row + 1
    Next
    For j = 13 To 15 &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set the rows for CC... values&lt;/STRONG&gt;&lt;/FONT&gt;
        GetValues(oMyValues, Row, j)
        Row = Row + 1
    Next&lt;BR /&gt;    &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Close excel table&lt;/STRONG&gt;&lt;/FONT&gt;
    GoExcel.Close
    Dim oModel As String
    oModel = Parameter("SIZE")&lt;BR /&gt;    &lt;STRONG&gt;&lt;FONT color="#FF0000"&gt;' Create new array list, taht will be used to fill the "SIZE_VALUES" parameter&lt;/FONT&gt;&lt;/STRONG&gt;
    Dim MyArrayList As New ArrayList&lt;BR /&gt;    &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Go throught each of rows in previously created object table&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;    ' and check if any of the rows match our needs&lt;/STRONG&gt;&lt;/FONT&gt;
    For i = 1 To UBound(oMyValues, 1)
	If oMyValues(i, 1) = oModel Then
	    MyArrayList.Add(oMyValues(i, 2))
            MyArrayList.Add(oMyValues(i, 3))
            MyArrayList.Add(oMyValues(i, 4))
            MyArrayList.Add(oMyValues(i, 5))
        End If
    Next&lt;BR /&gt;    &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Check if the parameter "SIZE_VALUES" does exist&lt;/STRONG&gt;&lt;/FONT&gt;
    NewParameter = CheckParam("SIZE_VALUES")&lt;BR /&gt;    &lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Set the values for "SIZE_VALUES" parameter&lt;/STRONG&gt;&lt;/FONT&gt;
    MultiValue.List("SIZE_VALUES") = MyArrayList
End Sub
&lt;BR /&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Sub-function used to load values from the excel table&lt;/STRONG&gt;&lt;/FONT&gt;
Private Sub GetValues(oMyValues As Object, Row As Integer, j As Integer)
    oMyValues(Row, 1) = GoExcel.CellValue("A" &amp;amp; j)
    oMyValues(Row, 2) = GoExcel.CellValue("B" &amp;amp; j)
    oMyValues(Row, 3) = GoExcel.CellValue("C" &amp;amp; j)
    oMyValues(Row, 4) = GoExcel.CellValue("D" &amp;amp; j)
    oMyValues(Row, 5) = GoExcel.CellValue("E" &amp;amp; j)
End Sub
&lt;BR /&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;' Function used to check if the parameter exists and create it if not&lt;/STRONG&gt;&lt;/FONT&gt;
Private Function CheckParam(oParaName As String) As String &lt;STRONG&gt;&lt;FONT color="#FF0000"&gt;' Return value as string&lt;/FONT&gt;&lt;/STRONG&gt;
   oParameters = ThisApplication.ActiveDocument.ComponentDefinition.Parameters.UserParameters
   Try&lt;BR /&gt;      Parameter(oParaName) = Parameter(oParaName)&lt;BR /&gt;      CheckParam = Parameter(oParaName)
   Catch
      oParameter = oParameters.AddByValue(oParaName, "", UnitsTypeEnum.kTextUnits)&lt;BR /&gt;      CheckParam = ""
   End Try
End Sub&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Here below is the rule to pick one of&amp;nbsp;the "SIZE" parameter values. Use the number to pick (first/second/...) value from the parameter list.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Try
    Parameter("SIZE") = Parameter("SIZE")&lt;BR /&gt;&lt;SPAN&gt;    Parameter&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;SIZE&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt; &lt;SPAN&gt;=&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;SIZE&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;&lt;SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN&gt;Item&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;1&lt;/STRONG&gt;&lt;/FONT&gt;&lt;SPAN&gt;)&lt;BR /&gt;&lt;/SPAN&gt;Catch
    MsgBox("The parameter 'SIZE' doesn't exist")
End Try&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 12 Feb 2016 15:06:37 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6037236#M61675</guid>
      <dc:creator>Owner2229</dc:creator>
      <dc:date>2016-02-12T15:06:37Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6037356#M61677</link>
      <description>&lt;P&gt;wow, i'm such a newbie [[face palm]] i couldn't understand what i was missing in the first snippet code&lt;/P&gt;&lt;P&gt;i've been staring at this code for days&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;thank you for all your help&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;[edit]&lt;/P&gt;&lt;P&gt;**i'm getting an error when i run this:&amp;nbsp;Error on Line 68 : 'End Function' expected.&lt;/P&gt;&lt;P&gt;&amp;nbsp;and my "SIZE_VALUES" is now a Multi-Value but not a complete list&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;did you do a part file to create this code and if you did could you attach it here and i'll compare it to my copy?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;thanks again &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;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;p.s.&lt;/P&gt;&lt;P&gt;do you think this is the best way to approach this task? or do you think there is a better way?&lt;/P&gt;</description>
      <pubDate>Fri, 12 Feb 2016 16:36:36 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6037356#M61677</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-02-12T16:36:36Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6038980#M61700</link>
      <description>&lt;P&gt;Hi, the error is obvious as on the last row I have "End Sub" instead of "End Function".&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The two code snipsets I send you in the last post are separate solutions, but you got it, right? &lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@7B4B80143EBEB4F250CEEC82342F6CA1/emoticons/1f609.png" alt=":winking_face:" title=":winking_face:" /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;No I didn't create any test files for this rule, so I wasn't able ot test it. I just made it blindly &lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@F982DDE76110C67DBDB6AF220B48480A/emoticons/1f604.png" alt=":grinning_face_with_smiling_eyes:" title=":grinning_face_with_smiling_eyes:" /&gt;&lt;/P&gt;&lt;P&gt;I was ussing the picture you posted in the first post as a data source, so if you have more date in the excel file, than you'll need to adjust the code.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In the first solution (FS) is missing the "SIZE-DD" from your picture. But it's included in the second solution.&lt;/P&gt;&lt;P&gt;In&amp;nbsp;FS it can be added at place where is this:&lt;/P&gt;&lt;PRE&gt;'And so on for C...&amp;nbsp;&amp;nbsp;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;It's 6th row from bottom.&lt;/P&gt;&lt;P&gt;If you want me to adjust the code for you then send me the excel file or tell me how many more rows and/or columns you have in it.&lt;/P&gt;&lt;P&gt;And if the empty/description rows are the same (two).&lt;/P&gt;&lt;P&gt;It can also be done programaticaly if it will vary over time.&lt;/P&gt;</description>
      <pubDate>Mon, 15 Feb 2016 06:31:14 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6038980#M61700</guid>
      <dc:creator>Owner2229</dc:creator>
      <dc:date>2016-02-15T06:31:14Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6041038#M61733</link>
      <description>&lt;P&gt;hey! thanks again for replying. i'm sorry for not getting back sooner&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;once again, thank you so much for your help. i really do appreciate all your efforts here.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;i did spend quite a few hours this past weekend going thru your code, and modifying the errors in the code and completing the code where you indicated.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;i will say that i'm very, very impressed that you wrote the code "blindly" and without creating a test model. like most ppl here, i'm teaching myself iLogic and without ppl like you and this forum, i'd still be quite lost.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;and to be honest, i don't fully understand (from my inexperience in iLogic) a good portion of your code, so i have to read each line of code a few times to get a small glimps of some understanding of it &lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@7B4B80143EBEB4F250CEEC82342F6CA1/emoticons/1f609.png" alt=":winking_face:" title=":winking_face:" /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;for example, the last bit of code (rule to pick one of the "SIZE" parameter values), i'm unsure what/how/where to do with this code.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;but, for the most part, i did manage to get your code working. tho what took you minutes took me a few hours LOL&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;thanks again&lt;/P&gt;</description>
      <pubDate>Tue, 16 Feb 2016 13:50:50 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6041038#M61733</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-02-16T13:50:50Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6042828#M61756</link>
      <description>&lt;P&gt;Hi, you mean this one below? I send it to you as a tool so you can use it as a separate rule to test your code.&lt;/P&gt;&lt;P&gt;It just checks if the parameter "&lt;STRONG&gt;SIZE&lt;/STRONG&gt;" exists and if so then it will pick the first value (so you dont need to go to parameters and look for it).&lt;/P&gt;&lt;P&gt;The zero in the "&lt;STRONG&gt;.Item(0)&lt;/STRONG&gt;" means it will pick the first item, because it starts numbering from zero instead of one.&lt;/P&gt;&lt;P&gt;So if we will change it to "&lt;STRONG&gt;&lt;FONT color="#000000"&gt;MultiValue.List("SIZE").Item(1)"&lt;/FONT&gt;&lt;/STRONG&gt;&lt;FONT color="#000000"&gt;, it will pick the second item from the list.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Try
    &lt;STRONG&gt;&lt;FONT color="#FF0000"&gt;' Atempt to read the parameter "SIZE"&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;    Parameter("SIZE") = Parameter("SIZE")&lt;BR /&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;    ' If it doesn't throw an error then it will pass here,&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;    ' so we can pick the first item from the list in "SIZE" parameter&lt;/STRONG&gt;&lt;/FONT&gt;
    Parameter("SIZE") = MultiValue.List("SIZE").Item(&lt;STRONG&gt;&lt;FONT color="#0000FF"&gt;0&lt;/FONT&gt;&lt;/STRONG&gt;)
Catch
&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;    ' If the reading of the parameter fails, the "Try" command will send us here&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;    ' As the reading of the parameter failed we can assume it doesn't exist&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;    MsgBox("The parameter 'SIZE' doesn't exist")
End Try&lt;/PRE&gt;</description>
      <pubDate>Wed, 17 Feb 2016 07:23:26 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6042828#M61756</guid>
      <dc:creator>Owner2229</dc:creator>
      <dc:date>2016-02-17T07:23:26Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic help to create multple MultiValue.List from an Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6043330#M61764</link>
      <description>&lt;P&gt;once again, thanks so much. i appreciate all your help here &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;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;trying to learn iLogic without this forum and helpful people like you would make this task more difficult. i have been using Inventor since R1 and only since 2013 have i attempted to learn iLogic (with very slow progress, i must say LOL)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;with your experience, is there any other more efficient way to approach this task? for example, instead of 2 separate rules, having one instead?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;best regards,&lt;/P&gt;&lt;P&gt;-Leonard&lt;/P&gt;</description>
      <pubDate>Wed, 17 Feb 2016 14:02:32 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-help-to-create-multple-multivalue-list-from-an-excel/m-p/6043330#M61764</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-02-17T14:02:32Z</dc:date>
    </item>
  </channel>
</rss>

