<?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: Sort Excel Rows in Alphabetical Order in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12900413#M169561</link>
    <description>&lt;P&gt;Here are the reference files i have selected:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AMHumiston_0-1721128865025.png" style="width: 600px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1387236iA6B3FBDD4E38A392/image-size/medium?v=v2&amp;amp;px=400" role="button" title="AMHumiston_0-1721128865025.png" alt="AMHumiston_0-1721128865025.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 16 Jul 2024 11:21:09 GMT</pubDate>
    <dc:creator>AndrewHumiston</dc:creator>
    <dc:date>2024-07-16T11:21:09Z</dc:date>
    <item>
      <title>Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12898695#M169508</link>
      <description>&lt;P&gt;Hello all!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I cant seem to get this one to work even with the hyper lengthly documentation online. It seems it may not be possible to do this as the sorting method requires a rather random formatting to get the items to sort.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Range("A1:A12").Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlNo&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can see beside the the Range.Sort there is a space, and the a key for what row to sort items by. I dont believe Inventors version of VBA supports this. Is there a way to get around this and has anyone successfully done this? Even previous posts of this topic were never anwsered.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Mon, 15 Jul 2024 16:24:59 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12898695#M169508</guid>
      <dc:creator>C_Haines_ENG</dc:creator>
      <dc:date>2024-07-15T16:24:59Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12899089#M169524</link>
      <description>&lt;P&gt;Afternoon,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I did a little digging and here is the solution i found.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;first ensure this reference file is checked. Located under the Tools menu bar in the VBA Editor See attached Image1_SortExcelRows &amp;amp; Image2_ExcelSortList_References_ScreenShot.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;This will enable you to access the object library from Excel.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You where on the right track, please see the code below and let me know what you think. if this solves your issue please like the post and mark as a solution.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;As always please reach out with further questions or concerns.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Sub SortExcelRange()&lt;/P&gt;&lt;P&gt;'set ref to workbook&lt;/P&gt;&lt;P&gt;Dim oWorkbook As Workbook&lt;BR /&gt;Set oWorkbook = GetObject("YOUR FILE PATH HERE WITH FILE NAME AND EXTENSION")&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;'set ref to active sheet&lt;/P&gt;&lt;P&gt;Dim oActiveSheet As WorkSheet&lt;BR /&gt;Set oActiveSheet = oWorkbook.Sheets.Item(1)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;'adjust range as needed, i used b2 as the column to sort&lt;/P&gt;&lt;P&gt;oActiveSheet.Range("a1:c12").Sort Key1:=oActiveSheet.Range("b2"), order1:=xlAscending&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;End Sub&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, 15 Jul 2024 19:36:01 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12899089#M169524</guid>
      <dc:creator>AndrewHumiston</dc:creator>
      <dc:date>2024-07-15T19:36:01Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12899166#M169526</link>
      <description>&lt;P&gt;Are you editing the Inventor VBA code in the VBA editor and not in the built in one? Would you be able to paste the "Imports" code so I can add it to my inventor? Doesnt work without that it seems.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 15 Jul 2024 20:05:14 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12899166#M169526</guid>
      <dc:creator>C_Haines_ENG</dc:creator>
      <dc:date>2024-07-15T20:05:14Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12899180#M169527</link>
      <description>&lt;P&gt;yes i'm running it in the Inventor VBA, do you have the Microsoft Excel Reference file checked? you should not need to import anything.&lt;/P&gt;</description>
      <pubDate>Mon, 15 Jul 2024 20:13:54 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12899180#M169527</guid>
      <dc:creator>AndrewHumiston</dc:creator>
      <dc:date>2024-07-15T20:13:54Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12899188#M169528</link>
      <description>&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AMHumiston_0-1721074471711.png" style="width: 600px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1386979i0D708DC0297543D5/image-size/medium?v=v2&amp;amp;px=400" role="button" title="AMHumiston_0-1721074471711.png" alt="AMHumiston_0-1721074471711.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Ensure this box is checked, it might be at the top of your list.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;it is found here:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AMHumiston_1-1721074504456.png" style="width: 600px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1386981i61C3177FA3D50533/image-size/medium?v=v2&amp;amp;px=400" role="button" title="AMHumiston_1-1721074504456.png" alt="AMHumiston_1-1721074504456.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 15 Jul 2024 20:15:08 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12899188#M169528</guid>
      <dc:creator>AndrewHumiston</dc:creator>
      <dc:date>2024-07-15T20:15:08Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12899219#M169531</link>
      <description>&lt;P&gt;Okay so I did find it, but it still doesnt work. "Method arguments must be enclosed in parentheses." and "'Range' is a type and cannot be used as an expression."&lt;/P&gt;</description>
      <pubDate>Mon, 15 Jul 2024 20:29:38 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12899219#M169531</guid>
      <dc:creator>C_Haines_ENG</dc:creator>
      <dc:date>2024-07-15T20:29:38Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12899228#M169532</link>
      <description>&lt;P&gt;is that error coming from the sort line?&lt;/P&gt;</description>
      <pubDate>Mon, 15 Jul 2024 20:33:34 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12899228#M169532</guid>
      <dc:creator>AndrewHumiston</dc:creator>
      <dc:date>2024-07-15T20:33:34Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12900413#M169561</link>
      <description>&lt;P&gt;Here are the reference files i have selected:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AMHumiston_0-1721128865025.png" style="width: 600px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1387236iA6B3FBDD4E38A392/image-size/medium?v=v2&amp;amp;px=400" role="button" title="AMHumiston_0-1721128865025.png" alt="AMHumiston_0-1721128865025.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 16 Jul 2024 11:21:09 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12900413#M169561</guid>
      <dc:creator>AndrewHumiston</dc:creator>
      <dc:date>2024-07-16T11:21:09Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12900606#M169569</link>
      <description>&lt;P&gt;The method argument one yes.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 16 Jul 2024 12:46:25 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12900606#M169569</guid>
      <dc:creator>C_Haines_ENG</dc:creator>
      <dc:date>2024-07-16T12:46:25Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12900768#M169575</link>
      <description>&lt;P&gt;please ensure your references match mine. that might be an issue.&lt;/P&gt;</description>
      <pubDate>Tue, 16 Jul 2024 14:03:54 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12900768#M169575</guid>
      <dc:creator>AndrewHumiston</dc:creator>
      <dc:date>2024-07-16T14:03:54Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12912264#M169782</link>
      <description>&lt;P&gt;Do I have to run the script in the VBA Editor? Can these references not be imported into the default editor?&lt;/P&gt;</description>
      <pubDate>Mon, 22 Jul 2024 13:32:21 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12912264#M169782</guid>
      <dc:creator>C_Haines_ENG</dc:creator>
      <dc:date>2024-07-22T13:32:21Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12912272#M169783</link>
      <description>&lt;P&gt;It is setup to run in a VBA editor.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;are&amp;nbsp; you using ilogic?&lt;/P&gt;</description>
      <pubDate>Mon, 22 Jul 2024 13:35:10 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12912272#M169783</guid>
      <dc:creator>AndrewHumiston</dc:creator>
      <dc:date>2024-07-22T13:35:10Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12912292#M169785</link>
      <description>&lt;P&gt;Yes. Is iLogic.&lt;/P&gt;</description>
      <pubDate>Mon, 22 Jul 2024 13:43:10 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12912292#M169785</guid>
      <dc:creator>C_Haines_ENG</dc:creator>
      <dc:date>2024-07-22T13:43:10Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12912340#M169786</link>
      <description>&lt;P&gt;Is this problem not possible in iLogic? I was under the impression that iLogic and VBA were nearly identical minus some formatting.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 22 Jul 2024 14:09:21 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12912340#M169786</guid>
      <dc:creator>C_Haines_ENG</dc:creator>
      <dc:date>2024-07-22T14:09:21Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12912378#M169787</link>
      <description>&lt;P&gt;i have it working in VBA, its a matter of getting access to the same properties in ilogic. i typically use VBA for this as its easier to format inside vba.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;let me toy around with ilogic and see what i can come up with.&lt;/P&gt;</description>
      <pubDate>Mon, 22 Jul 2024 14:25:29 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12912378#M169787</guid>
      <dc:creator>AndrewHumiston</dc:creator>
      <dc:date>2024-07-22T14:25:29Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12912380#M169788</link>
      <description>&lt;P&gt;i have it working in VBA, its a matter of getting access to the same properties in ilogic. i typically use VBA for this as its easier to format inside vba.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;let&lt;/P&gt;</description>
      <pubDate>Mon, 22 Jul 2024 14:26:07 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12912380#M169788</guid>
      <dc:creator>AndrewHumiston</dc:creator>
      <dc:date>2024-07-22T14:26:07Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12914527#M169823</link>
      <description>&lt;P&gt;Any luck with converting it to iLogic? I fear lack of formatting options in iLogic wont allow you to specify the parameters for how the sort should be done.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 23 Jul 2024 13:31:12 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12914527#M169823</guid>
      <dc:creator>C_Haines_ENG</dc:creator>
      <dc:date>2024-07-23T13:31:12Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12914592#M169828</link>
      <description>&lt;P&gt;that is what i am running into. we use a lot of excel sheets to drive our cad models and certain features i haven't figured out how to get access from ilogic.&lt;/P&gt;</description>
      <pubDate>Tue, 23 Jul 2024 13:34:23 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12914592#M169828</guid>
      <dc:creator>AndrewHumiston</dc:creator>
      <dc:date>2024-07-23T13:34:23Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12914656#M169832</link>
      <description>&lt;P&gt;I can get you started, this is why I was mentioning imports earlier.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="general"&gt;Imports Microsoft.Office.Interop 'To use excel 
Imports Microsoft.Office.Interop.Excel 'To use excel
AddReference "Microsoft.Office.Interop.Excel" 'To use excel 
BOMPath = "C:\BOM Calculator\PART_BOM.xlsx" 'FINAL DESTINATION OF BOM RESULTS

'[ CREATE EXCEL APPLICATION, INSERT HEADER, AND CLOSE PREVIOUS INSTANCE IF STILL OPEN]

Try : ExcelAPP = GetObject(BOMPath) : ExcelAPP.Save : ExcelAPP.Application.Quit : My.Computer.FileSystem.DeleteFile(BOMPath) : Catch : End Try

ExcelAPP = CreateObject("Excel.Application") : ExcelAPP.Visible = True: ExcelAPP.DisplayAlerts = False

'AppActivate(ExcelAPP)
ExcelWB = ExcelAPP.Workbooks.Add
ExcelWB.SaveAs(BOMPath)

With ExcelAPP
	
	.Range("A1") = "TEST"
	
End With

ExcelAPP = Nothing
	&lt;/LI-CODE&gt;</description>
      <pubDate>Tue, 23 Jul 2024 13:55:16 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12914656#M169832</guid>
      <dc:creator>C_Haines_ENG</dc:creator>
      <dc:date>2024-07-23T13:55:16Z</dc:date>
    </item>
    <item>
      <title>Re: Sort Excel Rows in Alphabetical Order</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12914661#M169833</link>
      <description>&lt;P&gt;let me tinker with this!&lt;/P&gt;</description>
      <pubDate>Tue, 23 Jul 2024 13:56:38 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/sort-excel-rows-in-alphabetical-order/m-p/12914661#M169833</guid>
      <dc:creator>AndrewHumiston</dc:creator>
      <dc:date>2024-07-23T13:56:38Z</dc:date>
    </item>
  </channel>
</rss>

