<?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: how do I get date form BOM using Ilogic in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-do-i-get-date-form-bom-using-ilogic/m-p/9982982#M119670</link>
    <description>&lt;P&gt;Do you know how to get my custom properties ? call G_L ?&lt;/P&gt;</description>
    <pubDate>Wed, 06 Jan 2021 20:28:07 GMT</pubDate>
    <dc:creator>Darkforce_the_ilogic_guy</dc:creator>
    <dc:date>2021-01-06T20:28:07Z</dc:date>
    <item>
      <title>how do I get date form BOM using Ilogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-do-i-get-date-form-bom-using-ilogic/m-p/9981606#M119650</link>
      <description>&lt;PRE&gt;&lt;SPAN&gt;Sub&lt;/SPAN&gt; &lt;SPAN&gt;main&lt;/SPAN&gt;()

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oDoc&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;AssemblyDocument&lt;/SPAN&gt;
&lt;SPAN&gt;oDoc&lt;/SPAN&gt; = &lt;SPAN&gt;ThisApplication&lt;/SPAN&gt;.&lt;SPAN&gt;ActiveDocument&lt;/SPAN&gt;


&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oBOM&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BOM&lt;/SPAN&gt;
&lt;SPAN&gt;oBOM&lt;/SPAN&gt; = &lt;SPAN&gt;oDoc&lt;/SPAN&gt;.&lt;SPAN&gt;ComponentDefinition&lt;/SPAN&gt;.&lt;SPAN&gt;BOM&lt;/SPAN&gt;

&lt;SPAN&gt;oBOM&lt;/SPAN&gt;.&lt;SPAN&gt;PartsOnlyViewEnabled&lt;/SPAN&gt; = &lt;SPAN&gt;True&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oBOMView&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BOMView&lt;/SPAN&gt;
&lt;SPAN&gt;oBOMView&lt;/SPAN&gt; = &lt;SPAN&gt;oBOM&lt;/SPAN&gt;.&lt;SPAN&gt;BOMViews&lt;/SPAN&gt;

&lt;SPAN&gt;bRows&lt;/SPAN&gt; = &lt;SPAN&gt;oBOMView&lt;/SPAN&gt;.&lt;SPAN&gt;BOMRows&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;bRow&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BOMRow&lt;/SPAN&gt;

&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;bRow&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;bRows&lt;/SPAN&gt;
	
&lt;SPAN&gt;'Enter code here&lt;/SPAN&gt;



	

&lt;SPAN&gt;Next&lt;/SPAN&gt;


&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Sub&lt;/SPAN&gt;
&lt;/PRE&gt;&lt;P&gt;I am trying to build an code that read&amp;nbsp; data form BOM. I want to read&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;item , part number, qty, description, G_L (Custom), Raw material, Status (Custom)&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;and add to an Excel .&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;but can´t get the&amp;nbsp; for each&amp;nbsp; to run&amp;nbsp; .... I was trying to rewrite an VBA code I found&amp;nbsp; on the net .. that I beleive would do almost what I want ..( see sample below)... any I did why it fail ... you are welcome to help with the rest of the code&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;'Public Sub Main()&lt;/SPAN&gt;

&lt;SPAN&gt;'Dim oDoc As AssemblyDocument&lt;/SPAN&gt;
&lt;SPAN&gt;'Set oDoc = ThisApplication.ActiveDocument&lt;/SPAN&gt;

&lt;SPAN&gt;'Dim oBOM As BOM&lt;/SPAN&gt;
&lt;SPAN&gt;'Set oBOM = oDoc.ComponentDefinition.BOM&lt;/SPAN&gt;

&lt;SPAN&gt;'oBOM.PartsOnlyViewEnabled = True&lt;/SPAN&gt;

&lt;SPAN&gt;'Dim oBOMView As BOMView&lt;/SPAN&gt;
&lt;SPAN&gt;'Set oBOMView = oBOM.BOMViews.Item("Parts Only")&lt;/SPAN&gt;

&lt;SPAN&gt;'Call ExportToExcel(oBOMView.BOMRows)&lt;/SPAN&gt;
&lt;SPAN&gt;'End Sub&lt;/SPAN&gt;

&lt;SPAN&gt;'Public Function ExportToExcel(bRows As BOMRowsEnumerator)&lt;/SPAN&gt;
&lt;SPAN&gt;'Dim xlApp As Excel.Application&lt;/SPAN&gt;
&lt;SPAN&gt;'Set xlApp = GetObject("", "Excel.Application.15")&lt;/SPAN&gt;

&lt;SPAN&gt;'Dim xlWorkbook As Workbook&lt;/SPAN&gt;
&lt;SPAN&gt;'Set xlWorkbook = xlApp.Workbooks.Open("C:\SolidCAD\Inventor Training Files\iLOGIC\Beam\Beam Assembly - BOM.xls")&lt;/SPAN&gt;

&lt;SPAN&gt;'Dim xlWorksheet As WorkSheet&lt;/SPAN&gt;
&lt;SPAN&gt;'Set xlWorksheet = xlWorkbook.Worksheets.Item("TEST")&lt;/SPAN&gt;

&lt;SPAN&gt;'Dim row As Integer&lt;/SPAN&gt;
&lt;SPAN&gt;'row = 5&lt;/SPAN&gt;

&lt;SPAN&gt;'xlWorksheet.Range("B4").Value = "ITEM"&lt;/SPAN&gt;
&lt;SPAN&gt;'xlWorksheet.Range("C4").Value = "QTY"&lt;/SPAN&gt;
&lt;SPAN&gt;'xlWorksheet.Range("D4").Value = "DESC"&lt;/SPAN&gt;
&lt;SPAN&gt;'xlWorksheet.Range("E4").Value = "Part Number"&lt;/SPAN&gt;

&lt;SPAN&gt;'Dim bRow As BOMRow&lt;/SPAN&gt;
&lt;SPAN&gt;'For Each bRow In bRows&lt;/SPAN&gt;
&lt;SPAN&gt;'Dim rDoc As Document&lt;/SPAN&gt;
&lt;SPAN&gt;'Set rDoc = bRow.ComponentDefinitions.Item(1).Document&lt;/SPAN&gt;

&lt;SPAN&gt;'Dim docPropertySet As PropertySet&lt;/SPAN&gt;
&lt;SPAN&gt;'Set docPropertySet = rDoc.PropertySets.Item("Design Tracking Properties")&lt;/SPAN&gt;


&lt;SPAN&gt;'xlWorksheet.Range("B" &amp;amp; row).Value = bRow.ItemNumber&lt;/SPAN&gt;
&lt;SPAN&gt;'xlWorksheet.Range("C" &amp;amp; row).Value = bRow.ItemQuantity&lt;/SPAN&gt;
&lt;SPAN&gt;'xlWorksheet.Range("D" &amp;amp; row).Value = docPropertySet.Item("Description").Value&lt;/SPAN&gt;
&lt;SPAN&gt;'xlWorksheet.Range("E" &amp;amp; row).Value = docPropertySet.Item("Part Number").Value&lt;/SPAN&gt;

&lt;SPAN&gt;'row = row + 1&lt;/SPAN&gt;
&lt;SPAN&gt;'Next&lt;/SPAN&gt;

&lt;SPAN&gt;'xlWorkbook.Save&lt;/SPAN&gt;
&lt;SPAN&gt;'xlWorkbook.Close (False)&lt;/SPAN&gt;
&lt;SPAN&gt;'xlApp.Quit&lt;/SPAN&gt;

&lt;SPAN&gt;'End Function&lt;/SPAN&gt;&lt;/PRE&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, 06 Jan 2021 11:24:55 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-do-i-get-date-form-bom-using-ilogic/m-p/9981606#M119650</guid>
      <dc:creator>Darkforce_the_ilogic_guy</dc:creator>
      <dc:date>2021-01-06T11:24:55Z</dc:date>
    </item>
    <item>
      <title>Re: how do I get date form BOM using Ilogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-do-i-get-date-form-bom-using-ilogic/m-p/9981707#M119651</link>
      <description>&lt;P&gt;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/5708980"&gt;@Darkforce_the_ilogic_guy&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Can you try this code and see if it works in iLogic? Please change your excel file and excel sheet if needed, I had copied the same from the code you provided.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;Public&lt;/SPAN&gt; &lt;SPAN&gt;Sub&lt;/SPAN&gt; &lt;SPAN&gt;Main&lt;/SPAN&gt;()

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oDoc&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;AssemblyDocument&lt;/SPAN&gt;
&lt;SPAN&gt;oDoc&lt;/SPAN&gt; = &lt;SPAN&gt;ThisApplication&lt;/SPAN&gt;.&lt;SPAN&gt;ActiveDocument&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oBOM&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BOM&lt;/SPAN&gt;
&lt;SPAN&gt;oBOM&lt;/SPAN&gt; = &lt;SPAN&gt;oDoc&lt;/SPAN&gt;.&lt;SPAN&gt;ComponentDefinition&lt;/SPAN&gt;.&lt;SPAN&gt;BOM&lt;/SPAN&gt;

&lt;SPAN&gt;oBOM&lt;/SPAN&gt;.&lt;SPAN&gt;PartsOnlyViewEnabled&lt;/SPAN&gt; = &lt;SPAN&gt;True&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oBOMView&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BOMView&lt;/SPAN&gt;
&lt;SPAN&gt;oBOMView&lt;/SPAN&gt; = &lt;SPAN&gt;oBOM&lt;/SPAN&gt;.&lt;SPAN&gt;BOMViews&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Parts Only"&lt;/SPAN&gt;)

&lt;SPAN&gt;Call&lt;/SPAN&gt; &lt;SPAN&gt;ExportToExcel&lt;/SPAN&gt;(&lt;SPAN&gt;oBOMView&lt;/SPAN&gt;.&lt;SPAN&gt;BOMRows&lt;/SPAN&gt;)
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Sub&lt;/SPAN&gt;

&lt;SPAN&gt;Public&lt;/SPAN&gt; &lt;SPAN&gt;Function&lt;/SPAN&gt; &lt;SPAN&gt;ExportToExcel&lt;/SPAN&gt;(&lt;SPAN&gt;bRows&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BOMRowsEnumerator&lt;/SPAN&gt;)
&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt; =&lt;SPAN&gt;"C:\SolidCAD\Inventor Training Files\iLOGIC\Beam\Beam Assembly - BOM.xlsx"&lt;/SPAN&gt;
&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt; = &lt;SPAN&gt;"TEST"&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;row&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Integer&lt;/SPAN&gt;
&lt;SPAN&gt;row&lt;/SPAN&gt; = 5

&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"B4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"Item"&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"C4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"QTY"&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"D4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"DESCR"&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"E4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"Material"&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;bRow&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BOMRow&lt;/SPAN&gt;
&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;bRow&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;bRows&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;rDoc&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Document&lt;/SPAN&gt;
&lt;SPAN&gt;rDoc&lt;/SPAN&gt; = &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ComponentDefinitions&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(1).&lt;SPAN&gt;Document&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;docPropertySet&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;PropertySet&lt;/SPAN&gt;
&lt;SPAN&gt;docPropertySet&lt;/SPAN&gt; = &lt;SPAN&gt;rDoc&lt;/SPAN&gt;.&lt;SPAN&gt;PropertySets&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Design Tracking Properties"&lt;/SPAN&gt;)


&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"B"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;) = &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ItemNumber&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"C"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;) = &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ItemQuantity&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"D"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;) = &lt;SPAN&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Description"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"E"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;) = &lt;SPAN&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Part Number"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt;

&lt;SPAN&gt;row&lt;/SPAN&gt; = &lt;SPAN&gt;row&lt;/SPAN&gt; + 1
&lt;SPAN&gt;Next&lt;/SPAN&gt;

&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Save&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Close&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;ClearCache&lt;/SPAN&gt;

&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Function&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hope this will be helpful.&lt;/P&gt;</description>
      <pubDate>Wed, 06 Jan 2021 12:27:23 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-do-i-get-date-form-bom-using-ilogic/m-p/9981707#M119651</guid>
      <dc:creator>dutt.thakar</dc:creator>
      <dc:date>2021-01-06T12:27:23Z</dc:date>
    </item>
    <item>
      <title>Re: how do I get date form BOM using Ilogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-do-i-get-date-form-bom-using-ilogic/m-p/9981765#M119653</link>
      <description>&lt;P&gt;Do you know how to make it all Levels with ?&amp;nbsp; and with an Delimiter.. I need the same output as if I save an Excel... but I want på write down in an templete files(Excel file)... and with the properties I name ealyer&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="bt_0-1609936417213.png" style="width: 400px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/862987i45D4D3AFDC20F926/image-size/medium?v=v2&amp;amp;px=400" role="button" title="bt_0-1609936417213.png" alt="bt_0-1609936417213.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 06 Jan 2021 12:35:57 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-do-i-get-date-form-bom-using-ilogic/m-p/9981765#M119653</guid>
      <dc:creator>Darkforce_the_ilogic_guy</dc:creator>
      <dc:date>2021-01-06T12:35:57Z</dc:date>
    </item>
    <item>
      <title>Re: how do I get date form BOM using Ilogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-do-i-get-date-form-bom-using-ilogic/m-p/9981912#M119655</link>
      <description>&lt;P&gt;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/5708980"&gt;@Darkforce_the_ilogic_guy&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Try this. You can edit the properties that you want to copy and add more in the BOLD part in code.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;Class&lt;/SPAN&gt; &lt;SPAN&gt;BOMEXport&lt;/SPAN&gt;
	&lt;SPAN&gt;Shared&lt;/SPAN&gt; &lt;SPAN&gt;row&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Integer&lt;/SPAN&gt; = 5
&lt;SPAN&gt;Public&lt;/SPAN&gt; &lt;SPAN&gt;Sub&lt;/SPAN&gt; &lt;SPAN&gt;Main&lt;/SPAN&gt;()

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oDoc&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;AssemblyDocument&lt;/SPAN&gt;
&lt;SPAN&gt;oDoc&lt;/SPAN&gt; = &lt;SPAN&gt;ThisApplication&lt;/SPAN&gt;.&lt;SPAN&gt;ActiveDocument&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oBOM&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BOM&lt;/SPAN&gt;
&lt;SPAN&gt;oBOM&lt;/SPAN&gt; = &lt;SPAN&gt;oDoc&lt;/SPAN&gt;.&lt;SPAN&gt;ComponentDefinition&lt;/SPAN&gt;.&lt;SPAN&gt;BOM&lt;/SPAN&gt;

&lt;SPAN&gt;oBOM&lt;/SPAN&gt;.&lt;SPAN&gt;StructuredViewEnabled&lt;/SPAN&gt; = &lt;SPAN&gt;True&lt;/SPAN&gt;
&lt;SPAN&gt;oBOM&lt;/SPAN&gt;.&lt;SPAN&gt;StructuredViewFirstLevelOnly&lt;/SPAN&gt; = &lt;SPAN&gt;False&lt;/SPAN&gt;
&lt;SPAN&gt;oBOM&lt;/SPAN&gt;.&lt;SPAN&gt;StructuredViewDelimiter&lt;/SPAN&gt; = &lt;SPAN&gt;"."&lt;/SPAN&gt;

&lt;SPAN&gt;oBOM&lt;/SPAN&gt;.&lt;SPAN&gt;PartsOnlyViewEnabled&lt;/SPAN&gt; = &lt;SPAN&gt;True&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oBOMView&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BOMView&lt;/SPAN&gt;
&lt;SPAN&gt;oBOMView&lt;/SPAN&gt; = &lt;SPAN&gt;oBOM&lt;/SPAN&gt;.&lt;SPAN&gt;BOMViews&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Structured"&lt;/SPAN&gt;)

&lt;SPAN&gt;Call&lt;/SPAN&gt; &lt;SPAN&gt;ExportToExcel&lt;/SPAN&gt;(&lt;SPAN&gt;oBOMView&lt;/SPAN&gt;.&lt;SPAN&gt;BOMRows&lt;/SPAN&gt;)

&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Sub&lt;/SPAN&gt;

&lt;SPAN&gt;Public&lt;/SPAN&gt; &lt;SPAN&gt;Function&lt;/SPAN&gt; &lt;SPAN&gt;ExportToExcel&lt;/SPAN&gt;(&lt;SPAN&gt;bRows&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BOMRowsEnumerator&lt;/SPAN&gt;)
&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt; =&lt;SPAN&gt;"C:\SolidCAD\Inventor Training Files\iLOGIC\Beam\Beam Assembly - BOM.xlsx"&lt;/SPAN&gt;
&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt; = &lt;SPAN&gt;"TEST"&lt;/SPAN&gt;


&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"B4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"Item"&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"C4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"QTY"&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"D4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"DESC"&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"E4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"Part Number"&lt;BR /&gt;&lt;/SPAN&gt;&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"F4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"G_L (Custom)" &lt;STRONG&gt;'add more line below as per your property requirement&lt;/STRONG&gt;&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;bRow&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BOMRow&lt;/SPAN&gt;
&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;bRow&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;bRows&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;rDoc&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Document&lt;/SPAN&gt;
&lt;SPAN&gt;rDoc&lt;/SPAN&gt; = &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ComponentDefinitions&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(1).&lt;SPAN&gt;Document&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;docPropertySet&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;PropertySet&lt;/SPAN&gt;
&lt;SPAN&gt;docPropertySet&lt;/SPAN&gt; = &lt;SPAN&gt;rDoc&lt;/SPAN&gt;.&lt;SPAN&gt;PropertySets&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Design Tracking Properties"&lt;/SPAN&gt;)


&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"B"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;) = &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ItemNumber&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"C"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;) = &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ItemQuantity&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"D"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;) = &lt;SPAN&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Description"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"E"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;) = &lt;SPAN&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Part Number"&lt;/SPAN&gt;).&lt;SPAN&gt;Value &lt;STRONG&gt;'add more line below as per your property requirement&lt;/STRONG&gt;&lt;/SPAN&gt;

&lt;SPAN&gt;row&lt;/SPAN&gt; = &lt;SPAN&gt;row&lt;/SPAN&gt; + 1

&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;Not&lt;/SPAN&gt; &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ChildRows&lt;/SPAN&gt; &lt;SPAN&gt;Is&lt;/SPAN&gt; &lt;SPAN&gt;Nothing&lt;/SPAN&gt;
	&lt;SPAN&gt;Call&lt;/SPAN&gt; &lt;SPAN&gt;ExportToExcel&lt;/SPAN&gt;(&lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ChildRows&lt;/SPAN&gt;)
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;
&lt;SPAN&gt;Next&lt;/SPAN&gt;

&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Save&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Close&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;ClearCache&lt;/SPAN&gt;

&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Function&lt;/SPAN&gt;

&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Class&lt;/SPAN&gt;&amp;nbsp;&amp;nbsp;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 06 Jan 2021 13:50:16 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-do-i-get-date-form-bom-using-ilogic/m-p/9981912#M119655</guid>
      <dc:creator>dutt.thakar</dc:creator>
      <dc:date>2021-01-06T13:50:16Z</dc:date>
    </item>
    <item>
      <title>Re: how do I get date form BOM using Ilogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-do-i-get-date-form-bom-using-ilogic/m-p/9982982#M119670</link>
      <description>&lt;P&gt;Do you know how to get my custom properties ? call G_L ?&lt;/P&gt;</description>
      <pubDate>Wed, 06 Jan 2021 20:28:07 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-do-i-get-date-form-bom-using-ilogic/m-p/9982982#M119670</guid>
      <dc:creator>Darkforce_the_ilogic_guy</dc:creator>
      <dc:date>2021-01-06T20:28:07Z</dc:date>
    </item>
    <item>
      <title>Re: how do I get date form BOM using Ilogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-do-i-get-date-form-bom-using-ilogic/m-p/9983861#M119676</link>
      <description>&lt;P&gt;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/5708980"&gt;@Darkforce_the_ilogic_guy&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;To get custom properties, you need to change the property set. To get all your custom Properties value, you need to reference them with &lt;STRONG&gt;"User defined Properties"&lt;/STRONG&gt; in property set. I have added these extra lines to the above code for getting G_L. Replace the below code in Public Function.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;Public&lt;/SPAN&gt; &lt;SPAN&gt;Function&lt;/SPAN&gt; &lt;SPAN&gt;ExportToExcel&lt;/SPAN&gt;(&lt;SPAN&gt;bRows&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BOMRowsEnumerator&lt;/SPAN&gt;)
&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt; =&lt;SPAN&gt;"C:\SolidCAD\Inventor Training Files\iLOGIC\Beam\Beam Assembly - BOM.xlsx"&lt;/SPAN&gt;
&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt; = &lt;SPAN&gt;"TEST"&lt;/SPAN&gt;

&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"B4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"Item"&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"C4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"QTY"&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"D4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"DESC"&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"E4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"Part Number"&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"F4"&lt;/SPAN&gt;) = &lt;SPAN&gt;"G_L"&lt;/SPAN&gt; &lt;SPAN&gt;'add more line below as per your property requirement&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;bRow&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BOMRow&lt;/SPAN&gt;
&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;bRow&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;bRows&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;rDoc&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Document&lt;/SPAN&gt;
&lt;SPAN&gt;rDoc&lt;/SPAN&gt; = &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ComponentDefinitions&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(1).&lt;SPAN&gt;Document&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;docPropertySet&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;PropertySet&lt;/SPAN&gt;
&lt;SPAN&gt;docPropertySet&lt;/SPAN&gt; = &lt;SPAN&gt;rDoc&lt;/SPAN&gt;.&lt;SPAN&gt;PropertySets&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Design Tracking Properties"&lt;/SPAN&gt;)


&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"B"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;) = &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ItemNumber&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"C"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;) = &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ItemQuantity&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"D"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;) = &lt;SPAN&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Description"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;,&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;,&lt;SPAN&gt;"E"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;) = &lt;SPAN&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Part Number"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; &lt;SPAN&gt;'add more line below as per your property requirement&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;docPropertySet1&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;PropertySet&lt;/SPAN&gt;
&lt;SPAN&gt;docPropertySet1&lt;/SPAN&gt; = &lt;SPAN&gt;rDoc&lt;/SPAN&gt;.&lt;SPAN&gt;PropertySets&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"User Defined Properties"&lt;/SPAN&gt;) &lt;BR /&gt;
&lt;STRONG&gt;'You can add below all your custom properties, they must be referenced with docPropertySet1&lt;/STRONG&gt;&lt;BR /&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelFile&lt;/SPAN&gt;, &lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;, &lt;SPAN&gt;"F"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;) = &lt;SPAN&gt;docPropertySet1&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"G_L"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt;
&lt;SPAN&gt;row&lt;/SPAN&gt; = &lt;SPAN&gt;row&lt;/SPAN&gt; + 1

&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;Not&lt;/SPAN&gt; &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ChildRows&lt;/SPAN&gt; &lt;SPAN&gt;Is&lt;/SPAN&gt; &lt;SPAN&gt;Nothing&lt;/SPAN&gt;
	&lt;SPAN&gt;Call&lt;/SPAN&gt; &lt;SPAN&gt;ExportToExcel&lt;/SPAN&gt;(&lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ChildRows&lt;/SPAN&gt;)
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;
&lt;SPAN&gt;Next&lt;/SPAN&gt;

&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Save&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Close&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;ClearCache&lt;/SPAN&gt;

&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Function&lt;/SPAN&gt;
&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hope this will be helpful&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 07 Jan 2021 07:43:22 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-do-i-get-date-form-bom-using-ilogic/m-p/9983861#M119676</guid>
      <dc:creator>dutt.thakar</dc:creator>
      <dc:date>2021-01-07T07:43:22Z</dc:date>
    </item>
  </channel>
</rss>

