<?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: Iproperties Export to Excel in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11404429#M142328</link>
    <description>&lt;P&gt;The .csv file to write to.&lt;/P&gt;</description>
    <pubDate>Tue, 06 Sep 2022 18:53:16 GMT</pubDate>
    <dc:creator>sn_cad</dc:creator>
    <dc:date>2022-09-06T18:53:16Z</dc:date>
    <item>
      <title>Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/9212487#M105725</link>
      <description>&lt;P&gt;Hi, I am trying to export the iproperties of all the drawings in our drawing folder to an excel sheet, is there an existing way to do this? I have put together an ilogic script from a bunch of other posts but I cant get it to work, I frequently get this error, Unspecified error (Exception from HRESULT: 0X80004005 (E_FAIL)). Any help would be much appreciated.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN style="color: #ff0000;"&gt;Sub&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;Main&lt;/SPAN&gt;()
	
	
	
	&lt;SPAN style="color: #808080;"&gt;'declare variable for inventory master excel file&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;excel_file&lt;/SPAN&gt; = &lt;SPAN style="color: #008080;"&gt;"C:\Users\mraymond\Documents\inventory-master.xlsx"&lt;/SPAN&gt;
	
	&lt;SPAN style="color: #808080;"&gt;'open excel file&lt;/SPAN&gt;
	&lt;SPAN style="color: #800080;"&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;Open&lt;/SPAN&gt;(&lt;SPAN style="color: #800000;"&gt;excel_file&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"Sheet1"&lt;/SPAN&gt;)
	
	&lt;SPAN style="color: #808080;"&gt;'Create folder variable and Select folder with drawings in it&lt;/SPAN&gt;
	&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;Folder&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;New&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;IO&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;DirectoryInfo&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"C:\Users\mraymond\Documents\R-Drive Copy\test\"&lt;/SPAN&gt;)
	
	&lt;SPAN style="color: #808080;"&gt;'Create file list variable that will contain list of files in string format&lt;/SPAN&gt;
	&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;FileList&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;New&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;List&lt;/SPAN&gt;(&lt;SPAN style="color: #ff0000;"&gt;Of&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;String&lt;/SPAN&gt;)
	
	&lt;SPAN style="color: #808080;"&gt;'for loop that will loop through each file found in folder variable and add to file list&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;File&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;IO&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;FileInfo&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;In&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;Folder&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;GetFiles&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"*.idw"&lt;/SPAN&gt;,&lt;SPAN style="color: #800000;"&gt;IO&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;SearchOption&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;AllDirectories&lt;/SPAN&gt;)
	    &lt;SPAN style="color: #ff0000;"&gt;If&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;File&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;FullName&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Contains&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"OldVersions"&lt;/SPAN&gt;) = &lt;SPAN style="color: #ff0000;"&gt;False&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;Then&lt;/SPAN&gt;
	        &lt;SPAN style="color: #800000;"&gt;FileList&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Add&lt;/SPAN&gt;(&lt;SPAN style="color: #800000;"&gt;File&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;FullName&lt;/SPAN&gt;)
	    &lt;SPAN style="color: #ff0000;"&gt;End&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;If&lt;/SPAN&gt;
	&lt;SPAN style="color: #ff0000;"&gt;Next&lt;/SPAN&gt;
	
	&lt;SPAN style="color: #808080;"&gt;'display count of files found in folder&lt;/SPAN&gt;
	&lt;SPAN style="color: #800000;"&gt;MsgBox&lt;/SPAN&gt;(&lt;SPAN style="color: #800000;"&gt;FileList&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Count&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #008080;"&gt;" Files were found!"&lt;/SPAN&gt;)
	
	&lt;SPAN style="color: #808080;"&gt;'create variable for document&lt;/SPAN&gt;
	&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;oDoc&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: #808080;"&gt;'for loop that goes through file on the file list variable&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;DocName&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;String&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;In&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;FileList&lt;/SPAN&gt;
	    &lt;SPAN style="color: #800000;"&gt;oDoc&lt;/SPAN&gt; = &lt;SPAN style="color: #800080;"&gt;ThisApplication&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Documents&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Open&lt;/SPAN&gt;(&lt;SPAN style="color: #800000;"&gt;DocName&lt;/SPAN&gt;, &lt;SPAN style="color: #ff0000;"&gt;True&lt;/SPAN&gt;)
		
		&lt;SPAN style="color: #808080;"&gt;'for loop to find the first empty row in the inventory master excel file&lt;/SPAN&gt;
		&lt;SPAN style="color: #ff0000;"&gt;Dim&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;i&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;Integer&lt;/SPAN&gt;
		&lt;SPAN style="color: #ff0000;"&gt;For&lt;/SPAN&gt; &lt;SPAN style="color: #800000;"&gt;i&lt;/SPAN&gt; = 2 &lt;SPAN style="color: #ff0000;"&gt;To&lt;/SPAN&gt; 20000
		&lt;SPAN style="color: #808080;"&gt;'find first empty cell in column A&lt;/SPAN&gt;
			&lt;SPAN style="color: #ff0000;"&gt;If&lt;/SPAN&gt; (&lt;SPAN style="color: #800080;"&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"A"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;i&lt;/SPAN&gt;) = &lt;SPAN style="color: #008080;"&gt;""&lt;/SPAN&gt;) &lt;SPAN style="color: #ff0000;"&gt;Then&lt;/SPAN&gt;
				&lt;SPAN style="color: #808080;"&gt;'this command will run on each document in the folder variable&lt;/SPAN&gt;
				&lt;SPAN style="color: #800080;"&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN style="color: #800000;"&gt;excel_file&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"Sheet1"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"A"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;i&lt;/SPAN&gt;) = &lt;SPAN style="color: #800080;"&gt;iProperties&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;Value&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Project"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"Part Number"&lt;/SPAN&gt;)
				&lt;SPAN style="color: #800080;"&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN style="color: #800000;"&gt;excel_file&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"Sheet1"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"B"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;i&lt;/SPAN&gt;) = &lt;SPAN style="color: #800080;"&gt;iProperties&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;Value&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Project"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"Revision Number"&lt;/SPAN&gt;)
				&lt;SPAN style="color: #800080;"&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN style="color: #800000;"&gt;excel_file&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"Sheet1"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"C"&lt;/SPAN&gt; &amp;amp; &lt;SPAN style="color: #800000;"&gt;i&lt;/SPAN&gt;) = &lt;SPAN style="color: #800080;"&gt;iProperties&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;Value&lt;/SPAN&gt;(&lt;SPAN style="color: #008080;"&gt;"Project"&lt;/SPAN&gt;, &lt;SPAN style="color: #008080;"&gt;"Description"&lt;/SPAN&gt;)
				&lt;SPAN style="color: #ff0000;"&gt;Exit&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;For&lt;/SPAN&gt;
			&lt;SPAN style="color: #ff0000;"&gt;Else&lt;/SPAN&gt;
				&lt;SPAN style="color: #800000;"&gt;i&lt;/SPAN&gt; = + 1
			&lt;SPAN style="color: #ff0000;"&gt;End&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;If&lt;/SPAN&gt;
				
			
		&lt;SPAN style="color: #ff0000;"&gt;Next&lt;/SPAN&gt;
		
	    &lt;SPAN style="color: #800000;"&gt;oDoc&lt;/SPAN&gt;.&lt;SPAN style="color: #800000;"&gt;Close&lt;/SPAN&gt;
	&lt;SPAN style="color: #ff0000;"&gt;Next&lt;/SPAN&gt;
	
	&lt;SPAN style="color: #800080;"&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;Save&lt;/SPAN&gt;
	&lt;SPAN style="color: #800080;"&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN style="color: #800080;"&gt;Close&lt;/SPAN&gt;
	
&lt;SPAN style="color: #ff0000;"&gt;End&lt;/SPAN&gt; &lt;SPAN style="color: #ff0000;"&gt;Sub&lt;/SPAN&gt;
&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 19 Dec 2019 17:03:44 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/9212487#M105725</guid>
      <dc:creator>mraymond7REU2</dc:creator>
      <dc:date>2019-12-19T17:03:44Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/9314049#M105733</link>
      <description>&lt;P&gt;I think the problem with your code might be that it does not run on the fil you want too , but I can&amp;nbsp; not be sure at this time.&amp;nbsp; I think I would be able to make the code you need. but there are a few think I need to know.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;First of are you sure the properties are on the IDW file ? the system i work on my self thoes not have the have the properties form the part/assambly synz over to the IDW... because we want to save space in the Vault database.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;and second you do you know what part of the code that fail ?&lt;/P&gt;</description>
      <pubDate>Wed, 12 Feb 2020 20:25:29 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/9314049#M105733</guid>
      <dc:creator>Darkforce_the_ilogic_guy</dc:creator>
      <dc:date>2020-02-12T20:25:29Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/9314289#M105735</link>
      <description>&lt;P&gt;I have not fund an code that work jet .. but I have fund some of the problem with the code&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;first of all&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;excel_file&lt;/SPAN&gt;, &lt;SPAN&gt;"Sheet1"&lt;/SPAN&gt;, &lt;SPAN&gt;"A"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;i&lt;/SPAN&gt;) = &lt;SPAN&gt;iProperties&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;(&lt;SPAN&gt;"Project"&lt;/SPAN&gt;, &lt;SPAN&gt;"Part Number"&lt;/SPAN&gt;)&lt;/PRE&gt;&lt;P&gt;it does not read the properties on the that you are open .. with the ilogic code .. but the properties on the file that you open to run the file ... but the code do run on my computer and work it does just not read the properties form the right fil.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;second thing&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;the code fail if excel are not close ... you might have to close all the excel in the joblist&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;3rd.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;It look like it also fail if the cell are not emtry when you start the code.... I am not 100 % sure of this&amp;nbsp; because it might just have been an Excel program that i have not fund and close..&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I use this code to do what your want .. just to open all drawing form an assambly ... maybe you can find a way to rewrite this .. I do not know how at det time and I have to go to bed now... I might look at it again later if i get the time&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;oRefDocs&lt;/SPAN&gt; = &lt;SPAN&gt;oAsmDoc&lt;/SPAN&gt;.&lt;SPAN&gt;AllReferencedDocuments&lt;/SPAN&gt;
&lt;SPAN&gt;'Dim oRefDoc As Document&lt;/SPAN&gt;
&lt;SPAN&gt;cell&lt;/SPAN&gt; = 2
&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oRefDoc&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oRefDocs&lt;/SPAN&gt;
	
	
	
	&lt;SPAN&gt;cell&lt;/SPAN&gt; = &lt;SPAN&gt;cell&lt;/SPAN&gt;+1
    &lt;SPAN&gt;idwPathName&lt;/SPAN&gt; = &lt;SPAN&gt;Left&lt;/SPAN&gt;(&lt;SPAN&gt;oRefDoc&lt;/SPAN&gt;.&lt;SPAN&gt;FullDocumentName&lt;/SPAN&gt;, &lt;SPAN&gt;Len&lt;/SPAN&gt;(&lt;SPAN&gt;oRefDoc&lt;/SPAN&gt;.&lt;SPAN&gt;FullDocumentName&lt;/SPAN&gt;) -3) &amp;amp; &lt;SPAN&gt;"idw"&lt;/SPAN&gt;
	&lt;SPAN&gt;debug&lt;/SPAN&gt;(&lt;SPAN&gt;idwPathName&lt;/SPAN&gt;.&lt;SPAN&gt;ToString&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;" "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"NewDrawning"&lt;/SPAN&gt;)
	&lt;SPAN&gt;'GoExcel.Open(ExcelPath, ExcelSheet)&lt;/SPAN&gt;
	&lt;SPAN&gt;'GoExcel.CellValue(ExcelPath, ExcelSheet, "B" + Cell.ToString) = idwPathName&lt;/SPAN&gt;
	

    &lt;SPAN&gt;' Check to see that the model has a drawing of the same path and name&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;'False Grafik off True Grafik on&lt;/SPAN&gt;
		&lt;SPAN&gt;'MessageBox.Show(idwPathName, "Title")&lt;/SPAN&gt;
		&lt;SPAN&gt;Try&lt;/SPAN&gt;
        &lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt; = &lt;SPAN&gt;ThisApplication&lt;/SPAN&gt;.&lt;SPAN&gt;Documents&lt;/SPAN&gt;.&lt;SPAN&gt;Open&lt;/SPAN&gt;(&lt;SPAN&gt;idwPathName&lt;/SPAN&gt;, &lt;SPAN&gt;False&lt;/SPAN&gt;)
		&lt;SPAN&gt;Catch&lt;/SPAN&gt;
				&lt;SPAN&gt;ExcelPath&lt;/SPAN&gt;  = &lt;SPAN&gt;"C:\Working Folder\CAD\Kallesoe\Kallesoe iLogic\PDFLOg.xlsx"&lt;/SPAN&gt;
	&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt; = &lt;SPAN&gt;"Log"&lt;/SPAN&gt;
	&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Open&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelPath&lt;/SPAN&gt;, &lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;)
	&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelPath&lt;/SPAN&gt;, &lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;, &lt;SPAN&gt;"B"&lt;/SPAN&gt; + &lt;SPAN&gt;cell&lt;/SPAN&gt;.&lt;SPAN&gt;ToString&lt;/SPAN&gt;) = &lt;SPAN&gt;Left&lt;/SPAN&gt;(&lt;SPAN&gt;oRefDoc&lt;/SPAN&gt;.&lt;SPAN&gt;FullDocumentName&lt;/SPAN&gt;, &lt;SPAN&gt;Len&lt;/SPAN&gt;(&lt;SPAN&gt;oRefDoc&lt;/SPAN&gt;.&lt;SPAN&gt;FullDocumentName&lt;/SPAN&gt;))
	&lt;SPAN&gt;'GoExcel.CellValue(ExcelPath, ExcelSheet, "B" + cell.ToString) = idwPathName&lt;/SPAN&gt;
	&lt;SPAN&gt;Try&lt;/SPAN&gt;
		
	&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelPath&lt;/SPAN&gt;, &lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;, &lt;SPAN&gt;"C"&lt;/SPAN&gt; + &lt;SPAN&gt;cell&lt;/SPAN&gt;.&lt;SPAN&gt;ToString&lt;/SPAN&gt;) =  &lt;SPAN&gt;iProperties&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;(&lt;SPAN&gt;oRefDoc&lt;/SPAN&gt;.&lt;SPAN&gt;DisplayName&lt;/SPAN&gt;, &lt;SPAN&gt;"Project"&lt;/SPAN&gt;, &lt;SPAN&gt;"Description"&lt;/SPAN&gt;)
	&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelPath&lt;/SPAN&gt;, &lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;, &lt;SPAN&gt;"D"&lt;/SPAN&gt; + &lt;SPAN&gt;cell&lt;/SPAN&gt;.&lt;SPAN&gt;ToString&lt;/SPAN&gt;) = &lt;SPAN&gt;iProperties&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;(&lt;SPAN&gt;oRefDoc&lt;/SPAN&gt;.&lt;SPAN&gt;DisplayName&lt;/SPAN&gt;, &lt;SPAN&gt;"Custom"&lt;/SPAN&gt;, &lt;SPAN&gt;"Part Description"&lt;/SPAN&gt;)
	
	
	&lt;SPAN&gt;Catch&lt;/SPAN&gt;
		&lt;SPAN&gt;oRefDoc&lt;/SPAN&gt;.&lt;SPAN&gt;DisplayName&lt;/SPAN&gt;=&lt;SPAN&gt;""&lt;/SPAN&gt;
	&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelPath&lt;/SPAN&gt;, &lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;, &lt;SPAN&gt;"C"&lt;/SPAN&gt; + &lt;SPAN&gt;cell&lt;/SPAN&gt;.&lt;SPAN&gt;ToString&lt;/SPAN&gt;) = &lt;SPAN&gt;iProperties&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;(&lt;SPAN&gt;oRefDoc&lt;/SPAN&gt;.&lt;SPAN&gt;DisplayName&lt;/SPAN&gt;, &lt;SPAN&gt;"Project"&lt;/SPAN&gt;, &lt;SPAN&gt;"Description"&lt;/SPAN&gt;)
	&lt;SPAN&gt;Try&lt;/SPAN&gt;
	&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelPath&lt;/SPAN&gt;, &lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;, &lt;SPAN&gt;"D"&lt;/SPAN&gt; + &lt;SPAN&gt;cell&lt;/SPAN&gt;.&lt;SPAN&gt;ToString&lt;/SPAN&gt;) = &lt;SPAN&gt;iProperties&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;(&lt;SPAN&gt;oRefDoc&lt;/SPAN&gt;.&lt;SPAN&gt;DisplayName&lt;/SPAN&gt;, &lt;SPAN&gt;"Custom"&lt;/SPAN&gt;, &lt;SPAN&gt;"Part Description"&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;debug&lt;/SPAN&gt;(&lt;SPAN&gt;"wrong displaynName "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;idwPathName&lt;/SPAN&gt;.&lt;SPAN&gt;ToString&lt;/SPAN&gt;)
		
	&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Try&lt;/SPAN&gt;
	&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Save&lt;/SPAN&gt;
	&lt;SPAN&gt;'GoExcel.Close&lt;/SPAN&gt;
	
		&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Try&lt;/SPAN&gt;
    &lt;SPAN&gt;If&lt;/SPAN&gt; (&lt;SPAN&gt;System&lt;/SPAN&gt;.&lt;SPAN&gt;IO&lt;/SPAN&gt;.&lt;SPAN&gt;File&lt;/SPAN&gt;.&lt;SPAN&gt;Exists&lt;/SPAN&gt;(&lt;SPAN&gt;idwPathName&lt;/SPAN&gt;)) &lt;SPAN&gt;Then&lt;/SPAN&gt;
				      
		&lt;SPAN&gt;ThisApplication&lt;/SPAN&gt;.&lt;SPAN&gt;Documents&lt;/SPAN&gt;.&lt;SPAN&gt;Open&lt;/SPAN&gt;(&lt;SPAN&gt;idwPathName&lt;/SPAN&gt;, &lt;SPAN&gt;True&lt;/SPAN&gt;) 
		&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;auto&lt;/SPAN&gt; = &lt;SPAN&gt;iLogicVb&lt;/SPAN&gt;.&lt;SPAN&gt;Automation&lt;/SPAN&gt;
	&lt;SPAN&gt;auto&lt;/SPAN&gt;.&lt;SPAN&gt;RunExternalRule&lt;/SPAN&gt;(&lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt;, &lt;SPAN&gt;"SavePDF"&lt;/SPAN&gt;)
		&lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Close&lt;/SPAN&gt;
		&lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Close&lt;/SPAN&gt;
			&lt;SPAN&gt;ExcelPath&lt;/SPAN&gt;  = &lt;SPAN&gt;"C:\Working Folder\CAD\Kallesoe\Kallesoe iLogic\PDFLOg.xlsx"&lt;/SPAN&gt;
	&lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt; = &lt;SPAN&gt;"Log"&lt;/SPAN&gt;
	&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Open&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelPath&lt;/SPAN&gt;, &lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;)
	&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;ExcelPath&lt;/SPAN&gt;, &lt;SPAN&gt;ExcelSheet&lt;/SPAN&gt;, &lt;SPAN&gt;"B"&lt;/SPAN&gt; + &lt;SPAN&gt;Cell&lt;/SPAN&gt;.&lt;SPAN&gt;ToString&lt;/SPAN&gt;) = &lt;SPAN&gt;idwPathName&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;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 12 Feb 2020 21:53:49 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/9314289#M105735</guid>
      <dc:creator>Darkforce_the_ilogic_guy</dc:creator>
      <dc:date>2020-02-12T21:53:49Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/9315031#M105745</link>
      <description>&lt;P&gt;Hello&amp;nbsp;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/8304051"&gt;@mraymond7REU2&lt;/a&gt;,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;regarding your first post. Try this code snippet and see if it works for you.&lt;/P&gt;&lt;P&gt;You just have to put your paths back.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Sub Main()
	
	
	
	'declare variable for inventory master excel file
	excel_file = "C:\Users\Aleksandar.Kr\Desktop\Kurze Übung.xlsx"
	
	'open excel file
	Dim oExcel = CreateObject("Excel.Application")
	Dim oWorkbook = oExcel.Workbooks.Open(excel_file)
	oExcel.Application.Visible = True
	
	'Create folder variable and Select folder with drawings in it
	Dim Folder As New IO.DirectoryInfo("C:\Users\Aleksandar.Kr\Desktop\test123\")
	
	'Create file list variable that will contain list of files in string format
	Dim FileList As New List(Of String)
	
	'for loop that will loop through each file found in folder variable and add to file list
	For Each File As IO.FileInfo In Folder.GetFiles("*.idw",IO.SearchOption.AllDirectories)
	    If File.FullName.Contains("OldVersions") = False Then
	        FileList.Add(File.FullName)
	    End If
	Next
	
	'display count of files found in folder
	MsgBox(FileList.Count &amp;amp; " Files were found!")
	
	'create variable for document
	Dim oDoc As Document
	
	'for loop that goes through file on the file list variable
	For Each DocName As String In FileList
	    oDoc = ThisApplication.Documents.Open(DocName, True)
		
		'for loop to find the first empty row in the inventory master excel file
		Dim i As Integer
		For i = 2 To 20000
		'find first empty cell in column A
			If (oWorkbook.Sheets("Sheet1").Cells(i, 1).Value = "") Then
				'this command will run on each document in the folder variable
				oWorkbook.Sheets("Sheet1").Cells(i, 1).Value = iProperties.Value("Project", "Part Number")
				oWorkbook.Sheets("Sheet1").Cells(i, 2).Value = iProperties.Value("Project", "Revision Number")
				oWorkbook.Sheets("Sheet1").Cells(i, 3).Value = iProperties.Value("Project", "Description")
				Exit For
			Else
				i = + 1
			End If
				
			
		Next
		
	    oDoc.Close
	Next
	
	oWorkbook.Save
	oWorkbook.Close
	
End Sub&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;regards,&lt;/P&gt;&lt;P&gt;Aleks&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 13 Feb 2020 07:44:27 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/9315031#M105745</guid>
      <dc:creator>fullevent</dc:creator>
      <dc:date>2020-02-13T07:44:27Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/9315645#M105767</link>
      <description>&lt;P&gt;I solved this a while ago and forgot to come back here to post my findings. Below is the code that I put together which has the added benefit of exporting to csv instead of excel so excel doesn't need to be installed on the machine and it prompts for the files to be exported and the csv file to export them to.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Imports System.IO
' Declare the Application object
Dim oApplication As Inventor.Application

' Obtain the Inventor Application object.
' This assumes Inventor is already running.
oApplication = GetObject(, "Inventor.Application")

' FOLDER selection dialog
Dim FilePATH As String = "FilePATH"
Dim dialog As New System.Windows.Forms.FolderBrowserDialog()
dialog.SelectedPath = "R:\Drawings"
dialog.Description = "Select Folder to Pull Drawing Properties From (recursive)"
If dialog.ShowDialog() = System.Windows.Forms.DialogResult.OK Then
	drawingDir = dialog.SelectedPath
Else
	MsgBox("canceled!")
End If

' FILE Selection dialog
Dim oFileDlg As Inventor.FileDialog = Nothing
InventorVb.Application.CreateFileDialog(oFileDlg)
oFileDlg.InitialDirectory = oOrigRefName
oFileDlg.CancelError = True
On Error Resume Next
oFileDlg.ShowOpen()
If Err.Number &amp;lt;&amp;gt; 0 Then
Return
ElseIf oFileDlg.FileName &amp;lt;&amp;gt; "" Then
selectedfile = oFileDlg.FileName
End If


'Dim drawingDir = "R:\Drawings"
For Each foundFile As String In My.Computer.FileSystem.GetFiles(drawingDir, FileIO.SearchOption.SearchAllSubDirectories, "*.idw")
	ThisDoc.Launch(foundFile)
	
	' Set a reference to the active document.
	' This assumes a document is open.
	Dim oDoc As Document
	oDoc = oApplication.ActiveDocument
	      
	' Obtain the PropertySets collection object
	Dim oPropsets As PropertySets
	oPropsets = oDoc.PropertySets
	
	PartNo = oPropsets.Item("{32853F0F-3444-11d1-9E93-0060B03C1CA6}").ItemByPropId(kPartNumberDesignTrackingProperties).Value
	Revision = oPropsets.Item("{F29F85E0-4FF9-1068-AB91-08002B27B3D9}").ItemByPropId(kRevisionSummaryInformation).Value
	Description = oPropsets.Item("{32853F0F-3444-11d1-9E93-0060B03C1CA6}").ItemByPropId(kDescriptionDesignTrackingProperties).Value

	'Write data info To CSV File
	Dim oAppend As System.IO.StreamWriter
	'selectedfile = "C:\Users\mraymond\Documents\drawings-local\test\inv-master.csv"
	oAppend = IO.File.AppendText(selectedfile)
	oAppend.WriteLine(PartNo &amp;amp; "," &amp;amp; Revision &amp;amp; "," &amp;amp; Chr(34) &amp;amp; Description &amp;amp; Chr(34))
	oAppend.Flush()
	oAppend.Close()
	
	ThisApplication.Documents.CloseAll()
	
Next&lt;/PRE&gt;</description>
      <pubDate>Thu, 13 Feb 2020 12:34:40 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/9315645#M105767</guid>
      <dc:creator>mraymond7REU2</dc:creator>
      <dc:date>2020-02-13T12:34:40Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/10385703#M125419</link>
      <description>Hi, I have a question, first folder location we select is to make selection of director where drawings are stored, may I ask what selection we should make in second dialogue box?</description>
      <pubDate>Sat, 12 Jun 2021 22:46:39 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/10385703#M125419</guid>
      <dc:creator>floccipier</dc:creator>
      <dc:date>2021-06-12T22:46:39Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11404429#M142328</link>
      <description>&lt;P&gt;The .csv file to write to.&lt;/P&gt;</description>
      <pubDate>Tue, 06 Sep 2022 18:53:16 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11404429#M142328</guid>
      <dc:creator>sn_cad</dc:creator>
      <dc:date>2022-09-06T18:53:16Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11955533#M152401</link>
      <description>&lt;P&gt;This works for me if my property is in Project.&amp;nbsp; However, if my property is in Custom, it cannot find the property.&lt;/P&gt;&lt;P&gt;For example, I have a Custom property named DESCRIPTION.&amp;nbsp; When I run the rule, I get an error iProperties: Cannot find a property named "DESCRIPTION".&amp;nbsp; It does exist in the part. See attachment.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;These are my three lines.&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;oWorkbook&lt;/SPAN&gt;.&lt;SPAN&gt;Sheets&lt;/SPAN&gt;(&lt;SPAN&gt;"Sheet1"&lt;/SPAN&gt;).&lt;SPAN&gt;Cells&lt;/SPAN&gt;(&lt;SPAN&gt;i&lt;/SPAN&gt;, 1).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;iProperties&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;(&lt;SPAN&gt;"Custom"&lt;/SPAN&gt;, &lt;SPAN&gt;"DESCRIPTION"&lt;/SPAN&gt;)
&lt;SPAN&gt;oWorkbook&lt;/SPAN&gt;.&lt;SPAN&gt;Sheets&lt;/SPAN&gt;(&lt;SPAN&gt;"Sheet1"&lt;/SPAN&gt;).&lt;SPAN&gt;Cells&lt;/SPAN&gt;(&lt;SPAN&gt;i&lt;/SPAN&gt;, 2).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;iProperties&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;(&lt;SPAN&gt;"Custom"&lt;/SPAN&gt;, &lt;SPAN&gt;"MANUFACTURER"&lt;/SPAN&gt;)
&lt;SPAN&gt;oWorkbook&lt;/SPAN&gt;.&lt;SPAN&gt;Sheets&lt;/SPAN&gt;(&lt;SPAN&gt;"Sheet1"&lt;/SPAN&gt;).&lt;SPAN&gt;Cells&lt;/SPAN&gt;(&lt;SPAN&gt;i&lt;/SPAN&gt;, 3).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;iProperties&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;(&lt;SPAN&gt;"Custom"&lt;/SPAN&gt;, &lt;SPAN&gt;"MANUFACTURERS_PART_NUMBER"&lt;/SPAN&gt;)&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 10 May 2023 21:42:55 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11955533#M152401</guid>
      <dc:creator>mark.martinezECRPT</dc:creator>
      <dc:date>2023-05-10T21:42:55Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11955759#M152403</link>
      <description>&lt;P&gt;Hi &lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/9716507"&gt;@mark.martinezECRPT&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Those iproperty snippets work great when you are in only one document but if you try to loop through documents the wrong document can get targeted. There is a method to target the iproperty through the filename but it is a little tricky.&amp;nbsp;&lt;/P&gt;&lt;P&gt;Try the API route see &lt;A href="https://modthemachine.typepad.com/my_weblog/iproperties/" target="_blank" rel="noopener"&gt;helpful article here&lt;/A&gt;. Once you have the document, set up the property sets then retrieve the property. Wrap the process in a try catch to error out if no custom iprop exists.&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;oDoc&lt;/SPAN&gt; = &lt;SPAN&gt;ThisApplication&lt;/SPAN&gt;.&lt;SPAN&gt;Documents&lt;/SPAN&gt;.&lt;SPAN&gt;Open&lt;/SPAN&gt;(&lt;SPAN&gt;DocName&lt;/SPAN&gt;, &lt;SPAN&gt;True&lt;/SPAN&gt;)&lt;BR /&gt;Try&lt;BR /&gt;' Obtain the PropertySets collection object &lt;BR /&gt;Dim oPropsets As PropertySets = oDoc.PropertySets &lt;BR /&gt;Dim description As String = oPropsets.Item("Inventor User Defined Properties").Item("DESCRIPTION").Value &lt;BR /&gt;Dim manufacturer As String = oPropsets.Item("Inventor User Defined Properties").Item("&lt;SPAN&gt;MANUFACTURER&lt;/SPAN&gt;").Value&lt;BR /&gt;Dim manufPartNo As String = oPropsets.Item("Inventor User Defined Properties").Item("&lt;SPAN&gt;MANUFACTURERS_PART_NUMBER&lt;/SPAN&gt;").Value&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;oWorkbook&lt;/SPAN&gt;.&lt;SPAN&gt;Sheets&lt;/SPAN&gt;(&lt;SPAN&gt;"Sheet1"&lt;/SPAN&gt;).&lt;SPAN&gt;Cells&lt;/SPAN&gt;(&lt;SPAN&gt;i&lt;/SPAN&gt;, 1).&lt;SPAN&gt;Value&lt;/SPAN&gt; = description
&lt;SPAN&gt;oWorkbook&lt;/SPAN&gt;.&lt;SPAN&gt;Sheets&lt;/SPAN&gt;(&lt;SPAN&gt;"Sheet1"&lt;/SPAN&gt;).&lt;SPAN&gt;Cells&lt;/SPAN&gt;(&lt;SPAN&gt;i&lt;/SPAN&gt;, 2).&lt;SPAN&gt;Value&lt;/SPAN&gt; = manufacturer
&lt;SPAN&gt;oWorkbook&lt;/SPAN&gt;.&lt;SPAN&gt;Sheets&lt;/SPAN&gt;(&lt;SPAN&gt;"Sheet1"&lt;/SPAN&gt;).&lt;SPAN&gt;Cells&lt;/SPAN&gt;(&lt;SPAN&gt;i&lt;/SPAN&gt;, 3).&lt;SPAN&gt;Value&lt;/SPAN&gt; = manufPartNo&amp;nbsp;&lt;BR /&gt;Catch&lt;BR /&gt;End Try&lt;BR /&gt;&amp;nbsp;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 11 May 2023 00:24:12 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11955759#M152403</guid>
      <dc:creator>A.Acheson</dc:creator>
      <dc:date>2023-05-11T00:24:12Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11957361#M152453</link>
      <description>&lt;P&gt;What I am finding out is that the rule runs only on the file that I run the rule on.&amp;nbsp; It opens all the files, but only the initial file is being searched for the Custom properties.&amp;nbsp; It doesn't search the properties in the opened files.&lt;/P&gt;</description>
      <pubDate>Thu, 11 May 2023 14:48:23 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11957361#M152453</guid>
      <dc:creator>mark.martinezECRPT</dc:creator>
      <dc:date>2023-05-11T14:48:23Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11957487#M152458</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/9716507"&gt;@mark.martinezECRPT&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Can you share the whole rule your using?&lt;/P&gt;</description>
      <pubDate>Thu, 11 May 2023 15:30:50 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11957487#M152458</guid>
      <dc:creator>A.Acheson</dc:creator>
      <dc:date>2023-05-11T15:30:50Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11957650#M152465</link>
      <description>&lt;P&gt;After fixing a few lines it runs but only on the first file.&amp;nbsp; It writes a line to the excel file but then it opens up the next file and freezes with the excel file open.&lt;/P&gt;</description>
      <pubDate>Thu, 11 May 2023 16:42:48 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11957650#M152465</guid>
      <dc:creator>mark.martinezECRPT</dc:creator>
      <dc:date>2023-05-11T16:42:48Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11958035#M152487</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/9716507"&gt;@mark.martinezECRPT&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;It looks like your excel cells are being overwritten for each filename which is why your not seeing results for the remaining files.&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can use this logger to test results without excel.&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;Logger&lt;/SPAN&gt;.&lt;SPAN&gt;Info&lt;/SPAN&gt;(&lt;SPAN&gt;description&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"-"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;manufacturer&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"-"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;manufPartNo&lt;/SPAN&gt;)&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;You will need to remove the for loop looping over the rows and use a counter to index the rows like below&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;i&lt;/SPAN&gt;=&lt;SPAN&gt;i&lt;/SPAN&gt;+1&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 11 May 2023 19:26:02 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11958035#M152487</guid>
      <dc:creator>A.Acheson</dc:creator>
      <dc:date>2023-05-11T19:26:02Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11958196#M152492</link>
      <description>&lt;P&gt;The i = i +1 worked great.&amp;nbsp; Thanks.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;What if I want to add Part Number from the Project tab?&amp;nbsp; Is this the correct way?&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;partnumber&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;oPropsets&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"Inventor Project Properties"&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;/PRE&gt;</description>
      <pubDate>Thu, 11 May 2023 21:03:13 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11958196#M152492</guid>
      <dc:creator>mark.martinezECRPT</dc:creator>
      <dc:date>2023-05-11T21:03:13Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11958241#M152493</link>
      <description>&lt;P&gt;I found it out.&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;Design Tracking Properties&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;Thanks.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 11 May 2023 21:26:13 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11958241#M152493</guid>
      <dc:creator>mark.martinezECRPT</dc:creator>
      <dc:date>2023-05-11T21:26:13Z</dc:date>
    </item>
    <item>
      <title>Re: Iproperties Export to Excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11958250#M152494</link>
      <description>&lt;DIV class=""&gt;&lt;DIV class=""&gt;&lt;P&gt;If you have a look at the previous linked article you will find that under "Design Tracking Properties" Property Set. I also converted that VBA retrieval code to ilogic so you can retrieve your own list whenever you like.&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;partnumber&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;oPropsets&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;"&lt;/SPAN&gt;Design Tracking Properties&lt;SPAN&gt;"&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;/PRE&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;DIV class=""&gt;&lt;DIV class=""&gt;&lt;DIV class=""&gt;&lt;DIV class=""&gt;&lt;BR /&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AAcheson_1-1683840294321.png" style="width: 600px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1213465i096959DDD410EF68/image-size/medium?v=v2&amp;amp;px=400" role="button" title="AAcheson_1-1683840294321.png" alt="AAcheson_1-1683840294321.png" /&gt;&lt;/span&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;/DIV&gt;&lt;DIV class=""&gt;&lt;DIV&gt;&lt;DIV class=""&gt;&lt;DIV class=""&gt;&amp;nbsp;Get your own iproperties by retrieving Property and Property Sets:&lt;PRE&gt;  Dim doc As Document = ThisApplication.ActiveDocument
  For Each ps As PropertySet In doc.PropertySets
    Logger.Info (ps.Name + " / " + ps.InternalName)
    For Each p As [Property] In ps
      Logger.Info ("  " + p.Name + " /" + Str(p.PropId))
    Next
  Next&lt;/PRE&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;</description>
      <pubDate>Thu, 11 May 2023 21:29:19 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/iproperties-export-to-excel/m-p/11958250#M152494</guid>
      <dc:creator>A.Acheson</dc:creator>
      <dc:date>2023-05-11T21:29:19Z</dc:date>
    </item>
  </channel>
</rss>

