<?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: get Part Number of referenced parts in Parts List in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/get-part-number-of-referenced-parts-in-parts-list/m-p/12297399#M158924</link>
    <description>&lt;P&gt;Oh, I found it in the end...&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;Not&lt;/SPAN&gt; &lt;SPAN&gt;ThisApplication&lt;/SPAN&gt;.&lt;SPAN&gt;ActiveDocument&lt;/SPAN&gt;.&lt;SPAN&gt;DocumentType&lt;/SPAN&gt; = &lt;SPAN&gt;kDrawingDocumentObject&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt;
	&lt;SPAN&gt;MessageBox&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;"Hey this rule only runs in Drawing Documents!"&lt;/SPAN&gt;)
	&lt;SPAN&gt;Exit&lt;/SPAN&gt; &lt;SPAN&gt;Sub&lt;/SPAN&gt;
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;DrawingDocument&lt;/SPAN&gt;
&lt;SPAN&gt;oDrawDoc&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;oSheet&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Sheet&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oPartsList&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;PartsList&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oPartsListRow&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;PartsListRow&lt;/SPAN&gt;
&lt;SPAN&gt;'Define Sheet counter&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;iSheetCount&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Integer&lt;/SPAN&gt; = 0

&lt;SPAN&gt;'iterate through all sheets&lt;/SPAN&gt;
&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oSheet&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Sheets&lt;/SPAN&gt;
	&lt;SPAN&gt;iSheetCount&lt;/SPAN&gt; = &lt;SPAN&gt;iSheetCount&lt;/SPAN&gt; + 1
	&lt;SPAN&gt;'Define Parts List counter&lt;/SPAN&gt;
	&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;iPartsListCount&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Integer&lt;/SPAN&gt; = 0
	&lt;SPAN&gt;'iterate through all Parts List, if there are more than 1	&lt;/SPAN&gt;
	&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oPartsList&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oSheet&lt;/SPAN&gt;.&lt;SPAN&gt;PartsLists&lt;/SPAN&gt;
		&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oPartsListName&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt;
		&lt;SPAN&gt;oPartsListName&lt;/SPAN&gt; = &lt;SPAN&gt;oPartsList&lt;/SPAN&gt;.&lt;SPAN&gt;Title&lt;/SPAN&gt;
		&lt;SPAN&gt;iPartsListCount&lt;/SPAN&gt; = &lt;SPAN&gt;iPartsListCount&lt;/SPAN&gt; + 1
		&lt;SPAN&gt;'Define row counter&lt;/SPAN&gt;
		&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;iRowCount&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Integer&lt;/SPAN&gt; = 0
		&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;i&lt;/SPAN&gt; = 1 &lt;SPAN&gt;To&lt;/SPAN&gt; &lt;SPAN&gt;oPartsList&lt;/SPAN&gt;.&lt;SPAN&gt;PartsListRows&lt;/SPAN&gt;.&lt;SPAN&gt;Count&lt;/SPAN&gt;
			&lt;SPAN&gt;'skip invisible lines&lt;/SPAN&gt;
			&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oPartsList&lt;/SPAN&gt;.&lt;SPAN&gt;PartsListRows&lt;/SPAN&gt;(&lt;SPAN&gt;i&lt;/SPAN&gt;).&lt;SPAN&gt;Visible&lt;/SPAN&gt; = &lt;SPAN&gt;"True"&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt;
				&lt;SPAN&gt;iRowCount&lt;/SPAN&gt; = &lt;SPAN&gt;iRowCount&lt;/SPAN&gt; + 1
				&lt;SPAN&gt;'Get Column "Part Number"&lt;/SPAN&gt;
				&lt;SPAN&gt;oCell&lt;/SPAN&gt; = &lt;SPAN&gt;oPartsList&lt;/SPAN&gt;.&lt;SPAN&gt;PartsListRows&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;i&lt;/SPAN&gt;).&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"PART NUMBER"&lt;/SPAN&gt;)			
				&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oPartNum&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;oCell&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;				
				&lt;SPAN&gt;MessageBox&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;"Sheet "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"("&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;iSheetCount&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;")"&lt;/SPAN&gt; &amp;amp; _
					&lt;SPAN&gt;vbLf&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"Parts List "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"("&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;iPartsListCount&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;")"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;" Named: "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;oPartsListName&lt;/SPAN&gt; &amp;amp; _
					&lt;SPAN&gt;vbLf&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;vbLf&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"Line "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"("&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;iRowCount&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;")"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;" PART NUMBER: "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;oPartNum&lt;/SPAN&gt;)				
			&lt;SPAN&gt;Else&lt;/SPAN&gt;
				&lt;SPAN&gt;'Skip invisible lines&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;Next&lt;/SPAN&gt;
&lt;SPAN&gt;Next&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 11 Oct 2023 16:16:53 GMT</pubDate>
    <dc:creator>emanuel.c</dc:creator>
    <dc:date>2023-10-11T16:16:53Z</dc:date>
    <item>
      <title>get Part Number of referenced parts in Parts List</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/get-part-number-of-referenced-parts-in-parts-list/m-p/12297363#M158922</link>
      <description>&lt;P&gt;How can I get the Part Number of each document (line) existing on a parts list?&lt;/P&gt;&lt;P&gt;I'm traversing each line in the parts list but don't know how to access part numbers of those referenced documents.&lt;/P&gt;&lt;P&gt;Thank you!&lt;/P&gt;</description>
      <pubDate>Tue, 10 Oct 2023 20:26:02 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/get-part-number-of-referenced-parts-in-parts-list/m-p/12297363#M158922</guid>
      <dc:creator>emanuel.c</dc:creator>
      <dc:date>2023-10-10T20:26:02Z</dc:date>
    </item>
    <item>
      <title>Re: get Part Number of referenced parts in Parts List</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/get-part-number-of-referenced-parts-in-parts-list/m-p/12297399#M158924</link>
      <description>&lt;P&gt;Oh, I found it in the end...&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;Not&lt;/SPAN&gt; &lt;SPAN&gt;ThisApplication&lt;/SPAN&gt;.&lt;SPAN&gt;ActiveDocument&lt;/SPAN&gt;.&lt;SPAN&gt;DocumentType&lt;/SPAN&gt; = &lt;SPAN&gt;kDrawingDocumentObject&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt;
	&lt;SPAN&gt;MessageBox&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;"Hey this rule only runs in Drawing Documents!"&lt;/SPAN&gt;)
	&lt;SPAN&gt;Exit&lt;/SPAN&gt; &lt;SPAN&gt;Sub&lt;/SPAN&gt;
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;DrawingDocument&lt;/SPAN&gt;
&lt;SPAN&gt;oDrawDoc&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;oSheet&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Sheet&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oPartsList&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;PartsList&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oPartsListRow&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;PartsListRow&lt;/SPAN&gt;
&lt;SPAN&gt;'Define Sheet counter&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;iSheetCount&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Integer&lt;/SPAN&gt; = 0

&lt;SPAN&gt;'iterate through all sheets&lt;/SPAN&gt;
&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oSheet&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Sheets&lt;/SPAN&gt;
	&lt;SPAN&gt;iSheetCount&lt;/SPAN&gt; = &lt;SPAN&gt;iSheetCount&lt;/SPAN&gt; + 1
	&lt;SPAN&gt;'Define Parts List counter&lt;/SPAN&gt;
	&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;iPartsListCount&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Integer&lt;/SPAN&gt; = 0
	&lt;SPAN&gt;'iterate through all Parts List, if there are more than 1	&lt;/SPAN&gt;
	&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oPartsList&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oSheet&lt;/SPAN&gt;.&lt;SPAN&gt;PartsLists&lt;/SPAN&gt;
		&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oPartsListName&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt;
		&lt;SPAN&gt;oPartsListName&lt;/SPAN&gt; = &lt;SPAN&gt;oPartsList&lt;/SPAN&gt;.&lt;SPAN&gt;Title&lt;/SPAN&gt;
		&lt;SPAN&gt;iPartsListCount&lt;/SPAN&gt; = &lt;SPAN&gt;iPartsListCount&lt;/SPAN&gt; + 1
		&lt;SPAN&gt;'Define row counter&lt;/SPAN&gt;
		&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;iRowCount&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Integer&lt;/SPAN&gt; = 0
		&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;i&lt;/SPAN&gt; = 1 &lt;SPAN&gt;To&lt;/SPAN&gt; &lt;SPAN&gt;oPartsList&lt;/SPAN&gt;.&lt;SPAN&gt;PartsListRows&lt;/SPAN&gt;.&lt;SPAN&gt;Count&lt;/SPAN&gt;
			&lt;SPAN&gt;'skip invisible lines&lt;/SPAN&gt;
			&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oPartsList&lt;/SPAN&gt;.&lt;SPAN&gt;PartsListRows&lt;/SPAN&gt;(&lt;SPAN&gt;i&lt;/SPAN&gt;).&lt;SPAN&gt;Visible&lt;/SPAN&gt; = &lt;SPAN&gt;"True"&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt;
				&lt;SPAN&gt;iRowCount&lt;/SPAN&gt; = &lt;SPAN&gt;iRowCount&lt;/SPAN&gt; + 1
				&lt;SPAN&gt;'Get Column "Part Number"&lt;/SPAN&gt;
				&lt;SPAN&gt;oCell&lt;/SPAN&gt; = &lt;SPAN&gt;oPartsList&lt;/SPAN&gt;.&lt;SPAN&gt;PartsListRows&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;i&lt;/SPAN&gt;).&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"PART NUMBER"&lt;/SPAN&gt;)			
				&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oPartNum&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;oCell&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;				
				&lt;SPAN&gt;MessageBox&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;"Sheet "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"("&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;iSheetCount&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;")"&lt;/SPAN&gt; &amp;amp; _
					&lt;SPAN&gt;vbLf&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"Parts List "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"("&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;iPartsListCount&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;")"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;" Named: "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;oPartsListName&lt;/SPAN&gt; &amp;amp; _
					&lt;SPAN&gt;vbLf&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;vbLf&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"Line "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"("&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;iRowCount&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;")"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;" PART NUMBER: "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;oPartNum&lt;/SPAN&gt;)				
			&lt;SPAN&gt;Else&lt;/SPAN&gt;
				&lt;SPAN&gt;'Skip invisible lines&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;Next&lt;/SPAN&gt;
&lt;SPAN&gt;Next&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 11 Oct 2023 16:16:53 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/get-part-number-of-referenced-parts-in-parts-list/m-p/12297399#M158924</guid>
      <dc:creator>emanuel.c</dc:creator>
      <dc:date>2023-10-11T16:16:53Z</dc:date>
    </item>
  </channel>
</rss>

