<?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 to excel custom properties in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-to-excel-custom-properties/m-p/9052602#M101636</link>
    <description>&lt;P&gt;hi &lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/4502881"&gt;@idealogicERZYZ&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;See code below &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;PRE&gt;&lt;SPAN style="color: #800000;"&gt;bRows&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;oBOMView&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;BOMRows&lt;/SPAN&gt;
&lt;SPAN style="color: #ff0000;"&gt;For&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;Each&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;bRow&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;In&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;bRows&lt;/SPAN&gt;

	&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;rDoc&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;Document&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;rDoc&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;bRow&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;ComponentDefinitions&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(1).&lt;SPAN style="color: #800000;"&gt;Document&lt;/SPAN&gt;
	
	&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;docPropertySet&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;PropertySet&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;docPropertySet&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;rDoc&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;PropertySets&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Design Tracking Properties"&lt;/SPAN&gt;)

	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"A"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;bRow&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;ItemNumber&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"C"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Part Number"&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"D"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Description"&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"E"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;bRow&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;ItemQuantity&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"F"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Vendor"&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"P"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Cost"&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt;
	
	&lt;SPAN style="color: #808080;"&gt;'----------------------------Here is what you need-------------------------------------------&lt;/SPAN&gt;
	&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;customPropSet&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;PropertySet&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;customPropSet&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;rDoc&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;PropertySets&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Inventor User Defined Properties"&lt;/SPAN&gt;)
	&lt;SPAN style="color: #808080;"&gt;'xlWorksheet.Range("Q" &amp;amp; Row).Value = customPropSet.Item("Welding").Value 'If you want True/False&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Q"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;customPropSet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Welding"&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Expression&lt;/SPAN&gt; &lt;SPAN style="color: #808080;"&gt;'If you want Yes/No&lt;/SPAN&gt;
	&lt;SPAN style="color: #808080;"&gt;'-----------------------------------------------------------------------&lt;/SPAN&gt;
&lt;SPAN style="color: #ff0000;"&gt;Next&lt;/SPAN&gt;&lt;/PRE&gt;</description>
    <pubDate>Fri, 27 Sep 2019 12:45:19 GMT</pubDate>
    <dc:creator>JhoelForshav</dc:creator>
    <dc:date>2019-09-27T12:45:19Z</dc:date>
    <item>
      <title>ilogic export to excel custom properties</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-to-excel-custom-properties/m-p/9052571#M101635</link>
      <description>&lt;P&gt;Hi,&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have a code snippet exporting Excel. I have described the standard iProperties. I would like to export the "Custom" property "Welding" which is in part files and has a yes or no value.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;.......&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&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;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;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN&gt;Range&lt;/SPAN&gt;(&lt;SPAN&gt;"A"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ItemNumber&lt;/SPAN&gt;
	&lt;SPAN&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN&gt;Range&lt;/SPAN&gt;(&lt;SPAN&gt;"C"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;).&lt;SPAN&gt;Value&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;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN&gt;Range&lt;/SPAN&gt;(&lt;SPAN&gt;"D"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;).&lt;SPAN&gt;Value&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;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN&gt;Range&lt;/SPAN&gt;(&lt;SPAN&gt;"E"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ItemQuantity&lt;/SPAN&gt;
	&lt;SPAN&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN&gt;Range&lt;/SPAN&gt;(&lt;SPAN&gt;"F"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Vendor"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt;
	&lt;SPAN&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN&gt;Range&lt;/SPAN&gt;(&lt;SPAN&gt;"P"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;row&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Cost"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&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;E&lt;/P&gt;</description>
      <pubDate>Fri, 27 Sep 2019 12:30:00 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-to-excel-custom-properties/m-p/9052571#M101635</guid>
      <dc:creator>idealogicERZYZ</dc:creator>
      <dc:date>2019-09-27T12:30:00Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export to excel custom properties</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-to-excel-custom-properties/m-p/9052602#M101636</link>
      <description>&lt;P&gt;hi &lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/4502881"&gt;@idealogicERZYZ&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;See code below &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;PRE&gt;&lt;SPAN style="color: #800000;"&gt;bRows&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;oBOMView&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;BOMRows&lt;/SPAN&gt;
&lt;SPAN style="color: #ff0000;"&gt;For&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;Each&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;bRow&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;In&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;bRows&lt;/SPAN&gt;

	&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;rDoc&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;Document&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;rDoc&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;bRow&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;ComponentDefinitions&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(1).&lt;SPAN style="color: #800000;"&gt;Document&lt;/SPAN&gt;
	
	&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;docPropertySet&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;PropertySet&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;docPropertySet&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;rDoc&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;PropertySets&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Design Tracking Properties"&lt;/SPAN&gt;)

	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"A"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;bRow&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;ItemNumber&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"C"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Part Number"&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"D"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Description"&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"E"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;bRow&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;ItemQuantity&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"F"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Vendor"&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"P"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Cost"&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt;
	
	&lt;SPAN style="color: #808080;"&gt;'----------------------------Here is what you need-------------------------------------------&lt;/SPAN&gt;
	&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;customPropSet&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;PropertySet&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;customPropSet&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;rDoc&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;PropertySets&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Inventor User Defined Properties"&lt;/SPAN&gt;)
	&lt;SPAN style="color: #808080;"&gt;'xlWorksheet.Range("Q" &amp;amp; Row).Value = customPropSet.Item("Welding").Value 'If you want True/False&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Range&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Q"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;Row&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Value&lt;/SPAN&gt; = &lt;SPAN style="color: #800000;"&gt;customPropSet&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Item&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Welding"&lt;/SPAN&gt;).&lt;SPAN style="color: #800000;"&gt;Expression&lt;/SPAN&gt; &lt;SPAN style="color: #808080;"&gt;'If you want Yes/No&lt;/SPAN&gt;
	&lt;SPAN style="color: #808080;"&gt;'-----------------------------------------------------------------------&lt;/SPAN&gt;
&lt;SPAN style="color: #ff0000;"&gt;Next&lt;/SPAN&gt;&lt;/PRE&gt;</description>
      <pubDate>Fri, 27 Sep 2019 12:45:19 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-to-excel-custom-properties/m-p/9052602#M101636</guid>
      <dc:creator>JhoelForshav</dc:creator>
      <dc:date>2019-09-27T12:45:19Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export to excel custom properties</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-to-excel-custom-properties/m-p/9052725#M101637</link>
      <description>&lt;P&gt;Thanks, still a question ...&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The script stops if the .ipt part does not have the "Welding" parameter. How to make nothing in the excle tab in the "Q" column? That the parts that do not have this parameter have an empty field in the "Q" column.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;E&lt;/P&gt;</description>
      <pubDate>Fri, 27 Sep 2019 13:15:27 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-to-excel-custom-properties/m-p/9052725#M101637</guid>
      <dc:creator>idealogicERZYZ</dc:creator>
      <dc:date>2019-09-27T13:15:27Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export to excel custom properties</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-to-excel-custom-properties/m-p/9052810#M101638</link>
      <description>&lt;P&gt;Hello, adding to the excellent contribution of &lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/5330176"&gt;@JhoelForshav&lt;/a&gt;&amp;nbsp;, can you add the instruction try - catch - end try?&lt;BR /&gt;You could add it if you don't have an "on error resume next" line before&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&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;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;docPropertySet&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;PropertySet&lt;/SPAN&gt;,&lt;SPAN&gt;customPropSet&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;PropertySet&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;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;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN&gt;Range&lt;/SPAN&gt;(&lt;SPAN&gt;"A"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;Row&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ItemNumber&lt;/SPAN&gt;
	&lt;SPAN&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN&gt;Range&lt;/SPAN&gt;(&lt;SPAN&gt;"C"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;Row&lt;/SPAN&gt;).&lt;SPAN&gt;Value&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;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN&gt;Range&lt;/SPAN&gt;(&lt;SPAN&gt;"D"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;Row&lt;/SPAN&gt;).&lt;SPAN&gt;Value&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;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN&gt;Range&lt;/SPAN&gt;(&lt;SPAN&gt;"E"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;Row&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;bRow&lt;/SPAN&gt;.&lt;SPAN&gt;ItemQuantity&lt;/SPAN&gt;
	&lt;SPAN&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN&gt;Range&lt;/SPAN&gt;(&lt;SPAN&gt;"F"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;Row&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Vendor"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt;
	&lt;SPAN&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN&gt;Range&lt;/SPAN&gt;(&lt;SPAN&gt;"P"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;Row&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;docPropertySet&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Cost"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt;
	
	&lt;SPAN&gt;Try&lt;/SPAN&gt;
	&lt;SPAN&gt;customPropSet&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;"Inventor User Defined Properties"&lt;/SPAN&gt;)
	&lt;SPAN&gt;'xlWorksheet.Range("Q" &amp;amp; Row).Value = customPropSet.Item("Welding").Value 'If you want True/False&lt;/SPAN&gt;
	&lt;SPAN&gt;xlWorksheet&lt;/SPAN&gt;.&lt;SPAN&gt;Range&lt;/SPAN&gt;(&lt;SPAN&gt;"Q"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;Row&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;customPropSet&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Welding"&lt;/SPAN&gt;).&lt;SPAN&gt;Expression&lt;/SPAN&gt; &lt;SPAN&gt;'If you want Yes/No&lt;/SPAN&gt;
	&lt;SPAN&gt;Catch&lt;/SPAN&gt;
	&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Try&lt;/SPAN&gt;
&lt;SPAN&gt;Next&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;I hope this helps with your problem. Regards&lt;/P&gt;</description>
      <pubDate>Fri, 27 Sep 2019 13:33:30 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-to-excel-custom-properties/m-p/9052810#M101638</guid>
      <dc:creator>Sergio.D.Suárez</dc:creator>
      <dc:date>2019-09-27T13:33:30Z</dc:date>
    </item>
    <item>
      <title>Re: ilogic export to excel custom properties</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-to-excel-custom-properties/m-p/9052834#M101639</link>
      <description>&lt;P&gt;Thank you&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;E&lt;/P&gt;</description>
      <pubDate>Fri, 27 Sep 2019 13:40:18 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-export-to-excel-custom-properties/m-p/9052834#M101639</guid>
      <dc:creator>idealogicERZYZ</dc:creator>
      <dc:date>2019-09-27T13:40:18Z</dc:date>
    </item>
  </channel>
</rss>

