<?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 export BOM in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638499#M78256</link>
    <description>&lt;P&gt;I believe my signature has a nice example listed of how to sort the BOM after export to excel.&lt;/P&gt;</description>
    <pubDate>Wed, 20 Dec 2017 14:29:29 GMT</pubDate>
    <dc:creator>MechMachineMan</dc:creator>
    <dc:date>2017-12-20T14:29:29Z</dc:date>
    <item>
      <title>ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638322#M78253</link>
      <description>&lt;P&gt;Hello,&lt;BR /&gt;I'm using the following rule:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Dim oDoc As AssemblyDocument&lt;BR /&gt;oDoc = ThisApplication.ActiveDocument&lt;/P&gt;&lt;P&gt;Dim oBOM As BOM&lt;BR /&gt;oBOM = oDoc.ComponentDefinition.BOM&lt;/P&gt;&lt;P&gt;oBOM.PartsOnlyViewEnabled = True&lt;/P&gt;&lt;P&gt;Dim oBOMView As BOMView&lt;BR /&gt;oBOMView = oBOM.BOMViews.Item("Strukturalny")&lt;/P&gt;&lt;P&gt;xlApp = CreateObject("Excel.Application")&lt;/P&gt;&lt;P&gt;'comment out or change to false&lt;BR /&gt;'in order to not show Excel&lt;BR /&gt;xlApp.Visible = True&lt;BR /&gt;xlWorkbook = xlApp.Workbooks.Open("C:\Temp\Szablon.xlsx")&lt;/P&gt;&lt;P&gt;xlWorksheet = xlWorkbook.Worksheets.Item("BOM")&lt;/P&gt;&lt;P&gt;Dim row As Integer&lt;BR /&gt;row = 3&lt;/P&gt;&lt;P&gt;'xlWorksheet.Range("B4").Value = "ITEM"&lt;BR /&gt;'xlWorksheet.Range("C4").Value = "QTY"&lt;BR /&gt;'xlWorksheet.Range("D4").Value = "DESC"&lt;BR /&gt;'xlWorksheet.Range("E4").Value = "Part Number"&lt;/P&gt;&lt;P&gt;'Dim bRow As bomRow&lt;BR /&gt;bRows = oBOMView.BOMRows&lt;BR /&gt;For Each bRow In bRows&lt;/P&gt;&lt;P&gt;Dim rDoc As Document&lt;BR /&gt;rDoc = bRow.ComponentDefinitions.Item(1).Document&lt;BR /&gt;&lt;BR /&gt;Dim docPropertySet As PropertySet&lt;BR /&gt;docPropertySet = rDoc.PropertySets.Item("Design Tracking Properties")&lt;BR /&gt;&lt;BR /&gt;xlWorksheet.Range("A" &amp;amp; row).Value = bRow.ItemNumber&lt;BR /&gt;xlWorksheet.Range("B" &amp;amp; row).Value = docPropertySet.Item("Part Number").Value&lt;BR /&gt;xlWorksheet.Range("C" &amp;amp; row).Value = bRow.ItemQuantity&lt;BR /&gt;xlWorksheet.Range("D" &amp;amp; row).Value = docPropertySet.Item("Stock number").Value&lt;BR /&gt;xlWorksheet.Range("E" &amp;amp; row).Value = docPropertySet.Item("Vendor").Value&lt;BR /&gt;xlWorksheet.Range("F" &amp;amp; row).Value = docPropertySet.Item("Description").Value&lt;BR /&gt;xlWorksheet.Range("G" &amp;amp; row).Value = docPropertySet.Item("Cost").Value&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;row = row + 1&lt;BR /&gt;Next&lt;/P&gt;&lt;P&gt;oNow = DateString &amp;amp; "_" &amp;amp; TimeString&lt;BR /&gt;oNow = oNow.Replace("/","_")&lt;BR /&gt;oNow = oNow.Replace(":","_")&lt;BR /&gt;xlWorkBook.SaveAs(Filename:="C:\Temp\BOM-" &amp;amp; oNow &amp;amp; ".xlsx")&lt;/P&gt;&lt;P&gt;xlWorkbook.Close (True)&lt;BR /&gt;xlApp.Quit&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;The problem is that using this rule after export the new element adds to my list at the end of my xls template.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 422px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/441331i99D9E85FCAD42B53/image-size/large?v=v2&amp;amp;px=999" role="button" title="image.png" alt="image.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 293px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/441333i3EC975A90A85D042/image-size/large?v=v2&amp;amp;px=999" role="button" title="image.png" alt="image.png" /&gt;&lt;/span&gt;&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;If I use the export icon from .iam - then structural BOM exports correctly:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 569px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/441334i7BB4A4A94EB31F31/image-size/large?v=v2&amp;amp;px=999" role="button" title="image.png" alt="image.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;And I get the correct xls:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 329px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/441340iA33F220806FF479A/image-size/large?v=v2&amp;amp;px=999" role="button" title="image.png" alt="image.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Any idea why this is happening ...&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Ed&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 13:41:41 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638322#M78253</guid>
      <dc:creator>idealogicERZYZ</dc:creator>
      <dc:date>2017-12-20T13:41:41Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638489#M78255</link>
      <description>&lt;P&gt;Because it is the latest item added.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I you look how inventor exports the Bom this is different because they do not use the Item Number.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Solution:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Sort your Excel file afterwards via coding&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 14:27:00 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638489#M78255</guid>
      <dc:creator>bradeneuropeArthur</dc:creator>
      <dc:date>2017-12-20T14:27:00Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638499#M78256</link>
      <description>&lt;P&gt;I believe my signature has a nice example listed of how to sort the BOM after export to excel.&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 14:29:29 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638499#M78256</guid>
      <dc:creator>MechMachineMan</dc:creator>
      <dc:date>2017-12-20T14:29:29Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638553#M78257</link>
      <description>&lt;P&gt;Justin,&lt;BR /&gt;But what solution ? Where is it ?&lt;/P&gt;&lt;P&gt;Please enter the link&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Ed&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 14:41:51 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638553#M78257</guid>
      <dc:creator>idealogicERZYZ</dc:creator>
      <dc:date>2017-12-20T14:41:51Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638580#M78258</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Put this to your code:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;' i is needed for the rows to be sorted. Maximum items of the BOM&lt;/P&gt;&lt;P&gt;&lt;FONT color="#0000ff" face="Consolas" size="2"&gt;Public&lt;/FONT&gt; &lt;FONT color="#0000ff" face="Consolas" size="2"&gt;Sub&lt;/FONT&gt;&lt;FONT face="Consolas" size="2"&gt; ExcelSortColumns(a &lt;/FONT&gt;&lt;FONT color="#0000ff" face="Consolas" size="2"&gt;As&lt;/FONT&gt; &lt;FONT color="#2b91af" face="Consolas" size="2"&gt;Workbook&lt;/FONT&gt;&lt;FONT face="Consolas" size="2"&gt;, i &lt;/FONT&gt;&lt;FONT color="#0000ff" face="Consolas" size="2"&gt;As&lt;/FONT&gt; &lt;FONT color="#0000ff" face="Consolas" size="2"&gt;Integer&lt;/FONT&gt;&lt;FONT face="Consolas" size="2"&gt;)&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT color="#0000ff" face="Consolas" size="2"&gt;Dim&lt;/FONT&gt;&lt;FONT face="Consolas" size="2"&gt; b &lt;/FONT&gt;&lt;FONT color="#0000ff" face="Consolas" size="2"&gt;As&lt;/FONT&gt; &lt;FONT color="#2b91af" face="Consolas" size="2"&gt;Worksheet&lt;/FONT&gt;&lt;FONT face="Consolas" size="2"&gt; = a.Worksheets(&lt;/FONT&gt;&lt;FONT color="#a31515" face="Consolas" size="2"&gt;"SHEETNAME"&lt;/FONT&gt;&lt;FONT face="Consolas" size="2"&gt;)&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT color="#0000ff" face="Consolas" size="2"&gt;Dim&lt;/FONT&gt;&lt;FONT face="Consolas" size="2"&gt; r &lt;/FONT&gt;&lt;FONT color="#0000ff" face="Consolas" size="2"&gt;As&lt;/FONT&gt; &lt;FONT color="#2b91af" face="Consolas" size="2"&gt;Range&lt;/FONT&gt;&lt;FONT face="Consolas" size="2"&gt; = b.Range(&lt;/FONT&gt;&lt;FONT color="#a31515" face="Consolas" size="2"&gt;"A1:G"&lt;/FONT&gt;&lt;FONT face="Consolas" size="2"&gt; &amp;amp; i)&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="Consolas" size="2"&gt;r.Sort(r.Columns(1), &lt;/FONT&gt;&lt;FONT color="#2b91af" face="Consolas" size="2"&gt;XlSortOrder&lt;/FONT&gt;&lt;FONT face="Consolas" size="2"&gt;.xlAscending, , , , , , &lt;/FONT&gt;&lt;FONT color="#2b91af" face="Consolas" size="2"&gt;XlYesNoGuess&lt;/FONT&gt;&lt;FONT face="Consolas" size="2"&gt;.xlYes, , , &lt;/FONT&gt;&lt;FONT color="#2b91af" face="Consolas" size="2"&gt;XlSortOrientation&lt;/FONT&gt;&lt;FONT face="Consolas" size="2"&gt;.xlSortColumns, &lt;/FONT&gt;&lt;FONT color="#2b91af" face="Consolas" size="2"&gt;XlSortMethod&lt;/FONT&gt;&lt;FONT face="Consolas" size="2"&gt;.xlPinYin, )&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT color="#0000ff" face="Consolas" size="2"&gt;End&lt;/FONT&gt; &lt;FONT color="#0000ff" face="Consolas" size="2"&gt;Sub&lt;/FONT&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 14:47:28 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638580#M78258</guid>
      <dc:creator>bradeneuropeArthur</dc:creator>
      <dc:date>2017-12-20T14:47:28Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638590#M78259</link>
      <description>&lt;P&gt;After exporting it is an easy matter - but why it does not export by the rule.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Ed&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 14:50:51 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638590#M78259</guid>
      <dc:creator>idealogicERZYZ</dc:creator>
      <dc:date>2017-12-20T14:50:51Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638602#M78260</link>
      <description>&lt;P&gt;as i replied.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;the item from the API is always the latest.&lt;/P&gt;&lt;P&gt;Also after renumbering the item of the API stays the latest Number.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The ItemNumber of the Bom is only a nickname&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If you have ie:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;API Item _________Bom ItemNumber&lt;/P&gt;&lt;P&gt;1&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;2&lt;/P&gt;&lt;P&gt;2&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;3&lt;/P&gt;&lt;P&gt;3&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;4&lt;/P&gt;&lt;P&gt;and you add one&lt;/P&gt;&lt;P&gt;4&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;5&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;and you renumber this&lt;/P&gt;&lt;P&gt;1&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;2&lt;/P&gt;&lt;P&gt;2&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;3&lt;/P&gt;&lt;P&gt;3&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;4&lt;/P&gt;&lt;P&gt;4&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;1&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;the API item keeps 4&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 14:57:29 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638602#M78260</guid>
      <dc:creator>bradeneuropeArthur</dc:creator>
      <dc:date>2017-12-20T14:57:29Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638650#M78261</link>
      <description>&lt;P&gt;Something does not work after my pasting.&lt;BR /&gt;Can you send the whole with my script?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Ed&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 15:05:40 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638650#M78261</guid>
      <dc:creator>idealogicERZYZ</dc:creator>
      <dc:date>2017-12-20T15:05:40Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638684#M78263</link>
      <description>&lt;PRE&gt;Dim oDoc As AssemblyDocument
oDoc = ThisApplication.ActiveDocument

Dim oBOM As BOM
oBOM = oDoc.ComponentDefinition.BOM

oBOM.PartsOnlyViewEnabled = True

Dim oBOMView As BOMView
oBOMView = oBOM.BOMViews.Item("Strukturalny")

xlApp = CreateObject("Excel.Application")

'comment out or change to false
'in order to not show Excel
xlApp.Visible = True
xlWorkbook = xlApp.Workbooks.Open("C:\Temp\Szablon.xlsx")

xlWorksheet = xlWorkbook.Worksheets.Item("BOM")

Dim row As Integer
row = 3

'xlWorksheet.Range("B4").Value = "ITEM"
'xlWorksheet.Range("C4").Value = "QTY"
'xlWorksheet.Range("D4").Value = "DESC"
'xlWorksheet.Range("E4").Value = "Part Number"

'Dim bRow As bomRow
bRows = oBOMView.BOMRows
For Each bRow In bRows

Dim rDoc As Document
rDoc = bRow.ComponentDefinitions.Item(1).Document

Dim docPropertySet As PropertySet
docPropertySet = rDoc.PropertySets.Item("Design Tracking Properties")

xlWorksheet.Range("A" &amp;amp; row).Value = bRow.ItemNumber
xlWorksheet.Range("B" &amp;amp; row).Value = docPropertySet.Item("Part Number").Value
xlWorksheet.Range("C" &amp;amp; row).Value = bRow.ItemQuantity
xlWorksheet.Range("D" &amp;amp; row).Value = docPropertySet.Item("Stock number").Value
xlWorksheet.Range("E" &amp;amp; row).Value = docPropertySet.Item("Vendor").Value
xlWorksheet.Range("F" &amp;amp; row).Value = docPropertySet.Item("Description").Value
xlWorksheet.Range("G" &amp;amp; row).Value = docPropertySet.Item("Cost").Value


row = row + 1
Next


Dim r As Range 
' How many Colums defined by G how many rows defined by i
r= xlWorksheet.Range("A1:G" &amp;amp; i)&lt;BR /&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT color="#ff0000"&gt;'IE&lt;/FONT&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;&lt;FONT color="#ff0000"&gt;'r= xlWorksheet.Range("A1:G100")&lt;/FONT&gt;&lt;/STRONG&gt;

r.Sort(r.Columns(1), XlSortOrder.xlAscending, , , , , , XlYesNoGuess.xlYes, , , XlSortOrientation.xlSortColumns, XlSortMethod.xlPinYin, )
oNow = DateString &amp;amp; "_" &amp;amp; TimeString
oNow = oNow.Replace("/","_")
oNow = oNow.Replace(":","_")
xlWorkBook.SaveAs(Filename:="C:\Temp\BOM-" &amp;amp; oNow &amp;amp; ".xlsx")

xlWorkbook.Close (True)
xlApp.Quit&lt;/PRE&gt;</description>
      <pubDate>Wed, 20 Dec 2017 15:17:29 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638684#M78263</guid>
      <dc:creator>bradeneuropeArthur</dc:creator>
      <dc:date>2017-12-20T15:17:29Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638753#M78265</link>
      <description>&lt;P&gt;Hi,&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Type: Range is not defined&lt;BR /&gt;An element was not declared: XISortOrder. It may be unavailable from the level of its protection.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 705px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/441424iF8FBE4B99A6C622B/image-size/large?v=v2&amp;amp;px=999" role="button" title="image.png" alt="image.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 15:38:12 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638753#M78265</guid>
      <dc:creator>idealogicERZYZ</dc:creator>
      <dc:date>2017-12-20T15:38:12Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638807#M78267</link>
      <description>&lt;P&gt;did you add a reference to Excel.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;This is missing I think!&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 15:46:30 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638807#M78267</guid>
      <dc:creator>bradeneuropeArthur</dc:creator>
      <dc:date>2017-12-20T15:46:30Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638914#M78270</link>
      <description>&lt;P&gt;I do not know how&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 16:17:15 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7638914#M78270</guid>
      <dc:creator>idealogicERZYZ</dc:creator>
      <dc:date>2017-12-20T16:17:15Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7639305#M78271</link>
      <description>&lt;P&gt;Hi,&lt;BR /&gt;&lt;BR /&gt;I can send you everything, but be carefull with using copied code from external without knowing how it works and how to modify it in future.&lt;BR /&gt;&lt;BR /&gt;I little training in I logic or better in a programming language would be very useful and critical for you I think.&lt;BR /&gt;&lt;BR /&gt;Please let me know how we can help you to a higher level regarding programming!?&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 18:11:16 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7639305#M78271</guid>
      <dc:creator>bradeneuropeArthur</dc:creator>
      <dc:date>2017-12-20T18:11:16Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7639773#M78276</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;For now, this code is enough for me. If you can, send me the whole.&lt;BR /&gt;I will be grateful. Thank you.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Ed&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 20:19:22 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7639773#M78276</guid>
      <dc:creator>idealogicERZYZ</dc:creator>
      <dc:date>2017-12-20T20:19:22Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7639793#M78278</link>
      <description>What version of excel are you using.&lt;BR /&gt;Need this for the reference path</description>
      <pubDate>Wed, 20 Dec 2017 20:26:31 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7639793#M78278</guid>
      <dc:creator>bradeneuropeArthur</dc:creator>
      <dc:date>2017-12-20T20:26:31Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7639810#M78279</link>
      <description>&lt;P&gt;MS Office 2016. Should I submit my template?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Ed&lt;/P&gt;</description>
      <pubDate>Wed, 20 Dec 2017 20:38:31 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7639810#M78279</guid>
      <dc:creator>idealogicERZYZ</dc:creator>
      <dc:date>2017-12-20T20:38:31Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7663611#M78581</link>
      <description>&lt;P&gt;Hello&lt;BR /&gt;Can I ask for everything, along with the code.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;greetings&lt;/P&gt;&lt;P&gt;Ed&lt;/P&gt;</description>
      <pubDate>Thu, 04 Jan 2018 12:56:54 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7663611#M78581</guid>
      <dc:creator>idealogicERZYZ</dc:creator>
      <dc:date>2018-01-04T12:56:54Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7664389#M78585</link>
      <description>Of course</description>
      <pubDate>Thu, 04 Jan 2018 16:33:02 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7664389#M78585</guid>
      <dc:creator>bradeneuropeArthur</dc:creator>
      <dc:date>2018-01-04T16:33:02Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7666454#M78607</link>
      <description>Please send me a private message so I will not forget.&lt;BR /&gt;I am not at my desk right now.</description>
      <pubDate>Fri, 05 Jan 2018 10:15:25 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7666454#M78607</guid>
      <dc:creator>bradeneuropeArthur</dc:creator>
      <dc:date>2018-01-05T10:15:25Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export BOM</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7666600#M78611</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;idealogic@onet.pl&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;thank you in advance&lt;BR /&gt;greetings&lt;/P&gt;&lt;P&gt;Ed&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 05 Jan 2018 11:25:05 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-bom/m-p/7666600#M78611</guid>
      <dc:creator>idealogicERZYZ</dc:creator>
      <dc:date>2018-01-05T11:25:05Z</dc:date>
    </item>
  </channel>
</rss>

