<?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: Write value to Excel table for validation in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/write-value-to-excel-table-for-validation/m-p/12458649#M161918</link>
    <description>&lt;P&gt;Hey Brent,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have not had much luck dealing with Excel file either. But looking at the helper note, it looks like they have ".xls" not ".xlsx". I am sure it isn't that simple but throwing it out there.&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="Walliguy_0-1703277493620.png" style="width: 600px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1307493i9D104DA03E5EBA98/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Walliguy_0-1703277493620.png" alt="Walliguy_0-1703277493620.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Have a great one,&lt;/P&gt;&lt;P&gt;Chris&lt;/P&gt;</description>
    <pubDate>Fri, 22 Dec 2023 20:38:21 GMT</pubDate>
    <dc:creator>Walliguy</dc:creator>
    <dc:date>2023-12-22T20:38:21Z</dc:date>
    <item>
      <title>Write value to Excel table for validation</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/write-value-to-excel-table-for-validation/m-p/12458598#M161916</link>
      <description>&lt;P&gt;I am attempting to Randomly Generate a Drawing/Program number and add it to an excel spreadsheet, the hope is that my rule would generate the number, check the spreadsheet to make sure it doesn't exist then add the new number in the next available row, if the number does exist a message box prompts the user to generate a new number. Parts of the code work however I am failing measurably at writing to the spread sheet.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in advance&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Brent&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 22 Dec 2023 19:55:53 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/write-value-to-excel-table-for-validation/m-p/12458598#M161916</guid>
      <dc:creator>bbrumfield</dc:creator>
      <dc:date>2023-12-22T19:55:53Z</dc:date>
    </item>
    <item>
      <title>Re: Write value to Excel table for validation</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/write-value-to-excel-table-for-validation/m-p/12458649#M161918</link>
      <description>&lt;P&gt;Hey Brent,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have not had much luck dealing with Excel file either. But looking at the helper note, it looks like they have ".xls" not ".xlsx". I am sure it isn't that simple but throwing it out there.&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="Walliguy_0-1703277493620.png" style="width: 600px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1307493i9D104DA03E5EBA98/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Walliguy_0-1703277493620.png" alt="Walliguy_0-1703277493620.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Have a great one,&lt;/P&gt;&lt;P&gt;Chris&lt;/P&gt;</description>
      <pubDate>Fri, 22 Dec 2023 20:38:21 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/write-value-to-excel-table-for-validation/m-p/12458649#M161918</guid>
      <dc:creator>Walliguy</dc:creator>
      <dc:date>2023-12-22T20:38:21Z</dc:date>
    </item>
    <item>
      <title>Re: Write value to Excel table for validation</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/write-value-to-excel-table-for-validation/m-p/12466392#M161983</link>
      <description>&lt;P&gt;Hi Chris,&lt;/P&gt;&lt;P&gt;Unfortunately, that wasn't the problem. I was able to finally write to Excel however I found that an insistence of Excel was left running when looking at task manager for each part number created and when pushing Parameters from an&lt;/P&gt;&lt;P&gt;assembly it slowed the process to a near stop. My thoughts for now, while a table with the newly created part numbers, description, user &amp;amp; date would be useful, the odds of repeating a 10-digit alpha number using both upper and lower case is pretty slim.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Brent&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Brent&lt;/P&gt;</description>
      <pubDate>Thu, 28 Dec 2023 23:51:35 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/write-value-to-excel-table-for-validation/m-p/12466392#M161983</guid>
      <dc:creator>bbrumfield</dc:creator>
      <dc:date>2023-12-28T23:51:35Z</dc:date>
    </item>
    <item>
      <title>Re: Write value to Excel table for validation</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/write-value-to-excel-table-for-validation/m-p/12466753#M161984</link>
      <description>&lt;P&gt;Hi &lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/1954827"&gt;@bbrumfield&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You should open and close the excel workbook before and after your operation is completed. The snippets for this are in the ilogic editor. If you need more control over the process then you can go the VB.NET excel dll route where you have the same power as VBA macro has.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 29 Dec 2023 06:36:43 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/write-value-to-excel-table-for-validation/m-p/12466753#M161984</guid>
      <dc:creator>A.Acheson</dc:creator>
      <dc:date>2023-12-29T06:36:43Z</dc:date>
    </item>
    <item>
      <title>Re: Write value to Excel table for validation</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/write-value-to-excel-table-for-validation/m-p/12467783#M161991</link>
      <description>&lt;P&gt;Update 12/30/2023&lt;/P&gt;&lt;P&gt;I was mistaken,&amp;nbsp;&lt;SPAN&gt;excelApp&lt;/SPAN&gt;.&lt;SPAN&gt;Visible&lt;/SPAN&gt; = &lt;SPAN&gt;True or False and&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN&gt;excelApp&lt;/SPAN&gt;.&lt;SPAN&gt;Quit&lt;/SPAN&gt;() make no difference the excel app continues to show in task manger. When pushing Parameters from an assembly or simply creating a new Part I end up with an instance showing in task manager for every part.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hi A.Acheson,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I was able to kill the process by changing excel.app.visible to true. I'm still uncertain if the rule is actually checking to see if the part number exists. My thoughts are that I would trigger the rule on creation of a new part and create some variation of the Code to run on sheet metal parts only when pushing Parameters from an Assembly.&amp;nbsp;&lt;/P&gt;&lt;P&gt;See Code Below (borrowed and modified from a snippet by Curtis Waguespack)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&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;Document&lt;/SPAN&gt; = &lt;SPAN&gt;ThisDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Document&lt;/SPAN&gt;	
&lt;SPAN&gt;iLogicVb&lt;/SPAN&gt;.&lt;SPAN&gt;UpdateWhenDone&lt;/SPAN&gt; = &lt;SPAN&gt;True&lt;/SPAN&gt;
&lt;SPAN&gt;Top&lt;/SPAN&gt;:
&lt;SPAN&gt;oFile&lt;/SPAN&gt; = &lt;SPAN&gt;"Path\File.xlsx"&lt;/SPAN&gt;
&lt;SPAN&gt;'define Excel Application object&lt;/SPAN&gt;
&lt;SPAN&gt;excelApp&lt;/SPAN&gt; = &lt;SPAN&gt;CreateObject&lt;/SPAN&gt;(&lt;SPAN&gt;"Excel.Application"&lt;/SPAN&gt;)
&lt;SPAN&gt;'set Excel to run invisibly, change to true if you want to run it visibly&lt;/SPAN&gt;
&lt;SPAN&gt;excelApp&lt;/SPAN&gt;.&lt;SPAN&gt;Visible&lt;/SPAN&gt; = &lt;SPAN&gt;True&lt;/SPAN&gt;
&lt;SPAN&gt;'suppress prompts (such as the compatibility checker)&lt;/SPAN&gt;
&lt;SPAN&gt;excelApp&lt;/SPAN&gt;.&lt;SPAN&gt;DisplayAlerts&lt;/SPAN&gt; = &lt;SPAN&gt;False&lt;/SPAN&gt;
	

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;xCharArray&lt;/SPAN&gt;() &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Char&lt;/SPAN&gt; = &lt;SPAN&gt;"abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"&lt;/SPAN&gt;.&lt;SPAN&gt;ToCharArray&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;xNoArray&lt;/SPAN&gt;() &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Char&lt;/SPAN&gt; = &lt;SPAN&gt;"0123456789"&lt;/SPAN&gt;.&lt;SPAN&gt;ToCharArray&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;xGenerator&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;System&lt;/SPAN&gt;.&lt;SPAN&gt;Random&lt;/SPAN&gt; = &lt;SPAN&gt;New&lt;/SPAN&gt; &lt;SPAN&gt;System&lt;/SPAN&gt;.&lt;SPAN&gt;Random&lt;/SPAN&gt;()
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;xStr&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;String&lt;/SPAN&gt;.&lt;SPAN&gt;Empty&lt;/SPAN&gt;

        &lt;SPAN&gt;While&lt;/SPAN&gt; &lt;SPAN&gt;xStr&lt;/SPAN&gt;.&lt;SPAN&gt;Length&lt;/SPAN&gt; &amp;lt; 10

            &lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;xGenerator&lt;/SPAN&gt;.&lt;SPAN&gt;Next&lt;/SPAN&gt;(0, 2) = 0 &lt;SPAN&gt;Then&lt;/SPAN&gt;
                &lt;SPAN&gt;xStr&lt;/SPAN&gt; &amp;amp;= &lt;SPAN&gt;xCharArray&lt;/SPAN&gt;(&lt;SPAN&gt;xGenerator&lt;/SPAN&gt;.&lt;SPAN&gt;Next&lt;/SPAN&gt;(0, &lt;SPAN&gt;xCharArray&lt;/SPAN&gt;.&lt;SPAN&gt;Length&lt;/SPAN&gt;)) 
            
			&lt;SPAN&gt;Else&lt;/SPAN&gt; 
				&lt;SPAN&gt;xStr&lt;/SPAN&gt; &amp;amp;= &lt;SPAN&gt;xNoArray&lt;/SPAN&gt;(&lt;SPAN&gt;xGenerator&lt;/SPAN&gt;.&lt;SPAN&gt;Next&lt;/SPAN&gt;(0, &lt;SPAN&gt;xNoArray&lt;/SPAN&gt;.&lt;SPAN&gt;Length&lt;/SPAN&gt;))
    
		&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;
		
        &lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;While&lt;/SPAN&gt;
		&lt;SPAN&gt;oValueToMatch&lt;/SPAN&gt; = &lt;SPAN&gt;xStr&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oProName1&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;"Default Table Part Number"&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oProName2&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;"Default Table Description"&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oProSet&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;PropertySet&lt;/SPAN&gt; = &lt;SPAN&gt;ThisApplication&lt;/SPAN&gt;.&lt;SPAN&gt;ActiveDocument&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;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oProp&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;Property&lt;/SPAN&gt;

&lt;SPAN&gt;Try&lt;/SPAN&gt;
	&lt;SPAN&gt;oProp&lt;/SPAN&gt; = &lt;SPAN&gt;oProSet&lt;/SPAN&gt;(&lt;SPAN&gt;oProName1&lt;/SPAN&gt;)
	&lt;SPAN&gt;oProp&lt;/SPAN&gt; = &lt;SPAN&gt;oProSet&lt;/SPAN&gt;(&lt;SPAN&gt;oProName2&lt;/SPAN&gt;)
	&lt;SPAN&gt;Catch&lt;/SPAN&gt;
	&lt;SPAN&gt;oProp&lt;/SPAN&gt; = &lt;SPAN&gt;oProSet&lt;/SPAN&gt;.&lt;SPAN&gt;Add&lt;/SPAN&gt;(&lt;SPAN&gt;""&lt;/SPAN&gt;,&lt;SPAN&gt;oProName1&lt;/SPAN&gt;)
	&lt;SPAN&gt;oProp&lt;/SPAN&gt; = &lt;SPAN&gt;oProSet&lt;/SPAN&gt;.&lt;SPAN&gt;Add&lt;/SPAN&gt;(&lt;SPAN&gt;""&lt;/SPAN&gt;,&lt;SPAN&gt;oProName2&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;iProperties&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;(&lt;SPAN&gt;"Custom"&lt;/SPAN&gt;,&lt;SPAN&gt;"Default Table Part Number"&lt;/SPAN&gt;)= &lt;SPAN&gt;""&lt;/SPAN&gt;  &lt;SPAN&gt;Then&lt;/SPAN&gt;
&lt;SPAN&gt;GoTo&lt;/SPAN&gt; &lt;SPAN&gt;DescNeeded&lt;/SPAN&gt;
&lt;SPAN&gt;Else&lt;/SPAN&gt; &lt;SPAN&gt;If&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;"Default Table Part Number"&lt;/SPAN&gt;) &amp;gt; &lt;SPAN&gt;""&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt;
&lt;SPAN&gt;GoTo&lt;/SPAN&gt; &lt;SPAN&gt;UserTime&lt;/SPAN&gt;	
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;

&lt;SPAN&gt;DescNeeded&lt;/SPAN&gt; :
&lt;SPAN&gt;Desc&lt;/SPAN&gt; = &lt;SPAN&gt;InputBox&lt;/SPAN&gt;(&lt;SPAN&gt;"Excel Table Description, ie: FT90FM, End Cap"&lt;/SPAN&gt;, &lt;SPAN&gt;"Enter Description Here"&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;"Default Table Part Number"&lt;/SPAN&gt;) = &lt;SPAN&gt;xStr&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;"Default Table Description"&lt;/SPAN&gt;) = &lt;SPAN&gt;Desc&lt;/SPAN&gt;
&lt;SPAN&gt;oTime&lt;/SPAN&gt; = &lt;SPAN&gt;Now&lt;/SPAN&gt;.&lt;SPAN&gt;ToShortDateString&lt;/SPAN&gt;
&lt;SPAN&gt;oUser&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;"ModifiedBy"&lt;/SPAN&gt;)
&lt;SPAN&gt;oDescriptionToMatch&lt;/SPAN&gt; = &lt;SPAN&gt;Desc&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;SPAN&gt;xStr&lt;/SPAN&gt;
&lt;SPAN&gt;Goto&lt;/SPAN&gt; &lt;SPAN&gt;StartPNAdd&lt;/SPAN&gt;

&lt;SPAN&gt;UserTime&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;SPAN&gt;xStr&lt;/SPAN&gt;
&lt;SPAN&gt;oTime&lt;/SPAN&gt; = &lt;SPAN&gt;Now&lt;/SPAN&gt;.&lt;SPAN&gt;ToShortDateString&lt;/SPAN&gt;
&lt;SPAN&gt;oUser&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;"ModifiedBy"&lt;/SPAN&gt;)
&lt;SPAN&gt;oDescriptionToMatch&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;"Default Table Description"&lt;/SPAN&gt;)

&lt;SPAN&gt;StartPNAdd&lt;/SPAN&gt;:
&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;Dir&lt;/SPAN&gt;(&lt;SPAN&gt;oFile&lt;/SPAN&gt;) &amp;lt;&amp;gt; &lt;SPAN&gt;""&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt;
	&lt;SPAN&gt;'workbook exists, open it&lt;/SPAN&gt;
	&lt;SPAN&gt;oWB&lt;/SPAN&gt; = &lt;SPAN&gt;excelApp&lt;/SPAN&gt;.&lt;SPAN&gt;Workbooks&lt;/SPAN&gt;.&lt;SPAN&gt;Open&lt;/SPAN&gt;(&lt;SPAN&gt;oFile&lt;/SPAN&gt;)
	&lt;SPAN&gt;oWS&lt;/SPAN&gt; = &lt;SPAN&gt;oWB&lt;/SPAN&gt;.&lt;SPAN&gt;Worksheets&lt;/SPAN&gt;(1)
&lt;SPAN&gt;Else&lt;/SPAN&gt;
	&lt;SPAN&gt;Return&lt;/SPAN&gt; &lt;SPAN&gt;'exit rule&lt;/SPAN&gt;
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;

&lt;SPAN&gt;'Loop through the rows In column A&lt;/SPAN&gt;

&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;iRow&lt;/SPAN&gt; = 2 &lt;SPAN&gt;To&lt;/SPAN&gt; &lt;SPAN&gt;oWS&lt;/SPAN&gt;.&lt;SPAN&gt;UsedRange&lt;/SPAN&gt;.&lt;SPAN&gt;Rows&lt;/SPAN&gt;.&lt;SPAN&gt;Count&lt;/SPAN&gt;
	&lt;SPAN&gt;'get value of the cell&lt;/SPAN&gt;
	&lt;SPAN&gt;oCellValue&lt;/SPAN&gt; = &lt;SPAN&gt;oWS&lt;/SPAN&gt;.&lt;SPAN&gt;Cells&lt;/SPAN&gt;(&lt;SPAN&gt;iRow&lt;/SPAN&gt;, &lt;SPAN&gt;"A"&lt;/SPAN&gt; ).&lt;SPAN&gt;Value&lt;/SPAN&gt; 
	&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oCellValue&lt;/SPAN&gt; = &lt;SPAN&gt;oValueToMatch&lt;/SPAN&gt;  &lt;SPAN&gt;Then&lt;/SPAN&gt; 
		&lt;SPAN&gt;oWS&lt;/SPAN&gt;.&lt;SPAN&gt;Cells&lt;/SPAN&gt;(&lt;SPAN&gt;iRow&lt;/SPAN&gt;, &lt;SPAN&gt;"A"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;oCellValue&lt;/SPAN&gt; + 1
		&lt;SPAN&gt;oFound&lt;/SPAN&gt; = &lt;SPAN&gt;True&lt;/SPAN&gt;
		&lt;SPAN&gt;Goto&lt;/SPAN&gt; &lt;SPAN&gt;Top&lt;/SPAN&gt;
	&lt;SPAN&gt;Else&lt;/SPAN&gt;
		&lt;SPAN&gt;oFound&lt;/SPAN&gt; = &lt;SPAN&gt;False&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;iRow&lt;/SPAN&gt;

&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oFound&lt;/SPAN&gt; = &lt;SPAN&gt;False&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt;
	&lt;SPAN&gt;oWS&lt;/SPAN&gt;.&lt;SPAN&gt;Cells&lt;/SPAN&gt;(&lt;SPAN&gt;oWS&lt;/SPAN&gt;.&lt;SPAN&gt;UsedRange&lt;/SPAN&gt;.&lt;SPAN&gt;Rows&lt;/SPAN&gt;.&lt;SPAN&gt;Count&lt;/SPAN&gt; + 1, &lt;SPAN&gt;"A"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;oValueToMatch&lt;/SPAN&gt; 
	&lt;SPAN&gt;oWS&lt;/SPAN&gt;.&lt;SPAN&gt;Cells&lt;/SPAN&gt;(&lt;SPAN&gt;oWS&lt;/SPAN&gt;.&lt;SPAN&gt;UsedRange&lt;/SPAN&gt;.&lt;SPAN&gt;Rows&lt;/SPAN&gt;.&lt;SPAN&gt;Count&lt;/SPAN&gt;, &lt;SPAN&gt;"B"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;oDescriptionToMatch&lt;/SPAN&gt;
	&lt;SPAN&gt;oWS&lt;/SPAN&gt;.&lt;SPAN&gt;Cells&lt;/SPAN&gt;(&lt;SPAN&gt;oWS&lt;/SPAN&gt;.&lt;SPAN&gt;UsedRange&lt;/SPAN&gt;.&lt;SPAN&gt;Rows&lt;/SPAN&gt;.&lt;SPAN&gt;Count&lt;/SPAN&gt;, &lt;SPAN&gt;"C"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;oTime&lt;/SPAN&gt;
	&lt;SPAN&gt;oWS&lt;/SPAN&gt;.&lt;SPAN&gt;Cells&lt;/SPAN&gt;(&lt;SPAN&gt;oWS&lt;/SPAN&gt;.&lt;SPAN&gt;UsedRange&lt;/SPAN&gt;.&lt;SPAN&gt;Rows&lt;/SPAN&gt;.&lt;SPAN&gt;Count&lt;/SPAN&gt;, &lt;SPAN&gt;"D"&lt;/SPAN&gt;).&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;oUser&lt;/SPAN&gt;
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;

&lt;SPAN&gt;'set all of the columns to autofit&lt;/SPAN&gt;
&lt;SPAN&gt;excelApp&lt;/SPAN&gt;.&lt;SPAN&gt;Columns&lt;/SPAN&gt;.&lt;SPAN&gt;AutoFit&lt;/SPAN&gt;

&lt;SPAN&gt;'save the file&lt;/SPAN&gt;
&lt;SPAN&gt;oWB&lt;/SPAN&gt;.&lt;SPAN&gt;Save&lt;/SPAN&gt;
&lt;SPAN&gt;oDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Save&lt;/SPAN&gt;
&lt;SPAN&gt;'close the workbook and the Excel Application&lt;/SPAN&gt;
&lt;SPAN&gt;oWB&lt;/SPAN&gt;.&lt;SPAN&gt;Close&lt;/SPAN&gt;
&lt;SPAN&gt;excelApp&lt;/SPAN&gt;.&lt;SPAN&gt;Quit&lt;/SPAN&gt;()
&lt;SPAN&gt;'excelApp = Nothing&lt;/SPAN&gt;

&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Sub&lt;/SPAN&gt;
 Thanks,&lt;BR /&gt;&lt;BR /&gt;Brent&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 30 Dec 2023 20:10:51 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/write-value-to-excel-table-for-validation/m-p/12467783#M161991</guid>
      <dc:creator>bbrumfield</dc:creator>
      <dc:date>2023-12-30T20:10:51Z</dc:date>
    </item>
    <item>
      <title>Re: Write value to Excel table for validation</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/write-value-to-excel-table-for-validation/m-p/12473404#M162051</link>
      <description>&lt;P&gt;Revisiting my original Post:&lt;/P&gt;&lt;P&gt;I believe all issues are resolved including verifying that the new number isn't a duplicate and killing excel from running in processes.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Brent&lt;/P&gt;</description>
      <pubDate>Wed, 03 Jan 2024 03:46:07 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/write-value-to-excel-table-for-validation/m-p/12473404#M162051</guid>
      <dc:creator>bbrumfield</dc:creator>
      <dc:date>2024-01-03T03:46:07Z</dc:date>
    </item>
  </channel>
</rss>

