<?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: Find and replace text in Custom table cells in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/find-and-replace-text-in-custom-table-cells/m-p/12240005#M157702</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/3867609"&gt;@martin.jerabekM5BZE&lt;/a&gt;.&amp;nbsp; Here is an iLogic rule example for finding &amp;amp; replacing text within either the Title, or the Cells of a CustomTable in a DrawingDocument.&amp;nbsp; It is currently set up to loop through each sheet, and each CustomTable it finds on each sheet.&amp;nbsp; Then after checking/processing its title, it will loop through each Row, and each Cell in each Row, checking/processing them.&lt;/P&gt;
&lt;LI-CODE lang="general"&gt;Sub Main
	If ThisDoc.Document.DocumentType &amp;lt;&amp;gt; DocumentTypeEnum.kDrawingDocumentObject Then
		MsgBox("A Drawing document must be active for this code to work. Exiting.", vbCritical, "")
		Exit Sub
	End If
	Dim oDDoc As DrawingDocument = ThisDoc.Document
	Dim oSheets As Inventor.Sheets = oDDoc.Sheets
	Dim sTextToFind As String = "ToFind"
	Dim sTextToReplaceIt As String = "Replacement"
	For Each oSheet As Inventor.Sheet In oSheets
		Dim oCTables As Inventor.CustomTables = oSheet.CustomTables
		If oCTables.Count = 0 Then Continue For 'skip to next oSheet in loop
		For Each oCTable As Inventor.CustomTable In oCTables
			If oCTable.Title.Contains(sTextToFind) Then
				Try
					oCTable.Title = oCTable.Title.Replace(sTextToFind, sTextToReplaceIt)
				Catch
					Logger.Error("Error replacing text in Title of CustomTable")
				End Try
			End If
			'&amp;lt;&amp;lt;&amp;lt; you can traverse the data in the table by rows or by columns &amp;gt;&amp;gt;&amp;gt;
			Dim oRows As Inventor.Rows = oCTable.Rows
			For Each oRow As Inventor.Row In oRows
				For Each oCell As Inventor.Cell In oRow
					If oCell.Value.Contains(sTextToFind) Then
						Try
							oCell.Value = oCell.Value.Replace(sTextToFind, sTextToReplaceIt)
						Catch
							Logger.Error("Error replacing text in Cell of CustomTable")
						End Try
					End If
				Next 'oCell
			Next 'oRow
		Next 'oCTable
	Next 'oSheet
	If oDDoc.RequiresUpdate Then oDDoc.Update2(True)
	'If oDDoc.Dirty Then oDDoc.Save2(False)
End Sub&lt;/LI-CODE&gt;
&lt;P&gt;If this solved your problem, or answered your question, please click &lt;SPAN&gt;&lt;STRONG&gt; ACCEPT SOLUTION &lt;/STRONG&gt;&lt;/SPAN&gt;.&lt;BR /&gt;Or, if this helped you, please click (LIKE or KUDOS) &lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@7401B55A0A518861312A0F851CD29320/emoticons/1f44d.png" alt=":thumbs_up:" title=":thumbs_up:" /&gt;.&lt;/P&gt;</description>
    <pubDate>Thu, 14 Sep 2023 11:29:18 GMT</pubDate>
    <dc:creator>WCrihfield</dc:creator>
    <dc:date>2023-09-14T11:29:18Z</dc:date>
    <item>
      <title>Find and replace text in Custom table cells</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/find-and-replace-text-in-custom-table-cells/m-p/12239847#M157697</link>
      <description>&lt;P&gt;Hello all,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I'm having an idw drawing generated from Woodwork for Inventor and it ganerates a Custom table with some material codes and descriptions for each part. I'm looking for an ilogic to go through all lists and all custom tables and find and replace specific text in all cells(material code).&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have already an ilogic to find and replace normal text or leaders, but I can't find a cell text replacement ilogic. I'm new to VBA and ilogic, I'm learning the basics, but this task is way too much for me.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Can anyone help?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thank you&lt;/P&gt;</description>
      <pubDate>Thu, 14 Sep 2023 10:08:24 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/find-and-replace-text-in-custom-table-cells/m-p/12239847#M157697</guid>
      <dc:creator>martin.jerabekM5BZE</dc:creator>
      <dc:date>2023-09-14T10:08:24Z</dc:date>
    </item>
    <item>
      <title>Re: Find and replace text in Custom table cells</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/find-and-replace-text-in-custom-table-cells/m-p/12240005#M157702</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/3867609"&gt;@martin.jerabekM5BZE&lt;/a&gt;.&amp;nbsp; Here is an iLogic rule example for finding &amp;amp; replacing text within either the Title, or the Cells of a CustomTable in a DrawingDocument.&amp;nbsp; It is currently set up to loop through each sheet, and each CustomTable it finds on each sheet.&amp;nbsp; Then after checking/processing its title, it will loop through each Row, and each Cell in each Row, checking/processing them.&lt;/P&gt;
&lt;LI-CODE lang="general"&gt;Sub Main
	If ThisDoc.Document.DocumentType &amp;lt;&amp;gt; DocumentTypeEnum.kDrawingDocumentObject Then
		MsgBox("A Drawing document must be active for this code to work. Exiting.", vbCritical, "")
		Exit Sub
	End If
	Dim oDDoc As DrawingDocument = ThisDoc.Document
	Dim oSheets As Inventor.Sheets = oDDoc.Sheets
	Dim sTextToFind As String = "ToFind"
	Dim sTextToReplaceIt As String = "Replacement"
	For Each oSheet As Inventor.Sheet In oSheets
		Dim oCTables As Inventor.CustomTables = oSheet.CustomTables
		If oCTables.Count = 0 Then Continue For 'skip to next oSheet in loop
		For Each oCTable As Inventor.CustomTable In oCTables
			If oCTable.Title.Contains(sTextToFind) Then
				Try
					oCTable.Title = oCTable.Title.Replace(sTextToFind, sTextToReplaceIt)
				Catch
					Logger.Error("Error replacing text in Title of CustomTable")
				End Try
			End If
			'&amp;lt;&amp;lt;&amp;lt; you can traverse the data in the table by rows or by columns &amp;gt;&amp;gt;&amp;gt;
			Dim oRows As Inventor.Rows = oCTable.Rows
			For Each oRow As Inventor.Row In oRows
				For Each oCell As Inventor.Cell In oRow
					If oCell.Value.Contains(sTextToFind) Then
						Try
							oCell.Value = oCell.Value.Replace(sTextToFind, sTextToReplaceIt)
						Catch
							Logger.Error("Error replacing text in Cell of CustomTable")
						End Try
					End If
				Next 'oCell
			Next 'oRow
		Next 'oCTable
	Next 'oSheet
	If oDDoc.RequiresUpdate Then oDDoc.Update2(True)
	'If oDDoc.Dirty Then oDDoc.Save2(False)
End Sub&lt;/LI-CODE&gt;
&lt;P&gt;If this solved your problem, or answered your question, please click &lt;SPAN&gt;&lt;STRONG&gt; ACCEPT SOLUTION &lt;/STRONG&gt;&lt;/SPAN&gt;.&lt;BR /&gt;Or, if this helped you, please click (LIKE or KUDOS) &lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@7401B55A0A518861312A0F851CD29320/emoticons/1f44d.png" alt=":thumbs_up:" title=":thumbs_up:" /&gt;.&lt;/P&gt;</description>
      <pubDate>Thu, 14 Sep 2023 11:29:18 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/find-and-replace-text-in-custom-table-cells/m-p/12240005#M157702</guid>
      <dc:creator>WCrihfield</dc:creator>
      <dc:date>2023-09-14T11:29:18Z</dc:date>
    </item>
    <item>
      <title>Re: Find and replace text in Custom table cells</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/find-and-replace-text-in-custom-table-cells/m-p/12240036#M157703</link>
      <description>&lt;P&gt;Amazing. Thank you, that just works excelent. I wouldn't be able to write that code. I have just added an input box to the code and it is awesome.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thank you&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;If&lt;/SPAN&gt; &lt;SPAN&gt;ThisDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Document&lt;/SPAN&gt;.&lt;SPAN&gt;DocumentType&lt;/SPAN&gt; &amp;lt;&amp;gt; &lt;SPAN&gt;DocumentTypeEnum&lt;/SPAN&gt;.&lt;SPAN&gt;kDrawingDocumentObject&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt;
		&lt;SPAN&gt;MsgBox&lt;/SPAN&gt;(&lt;SPAN&gt;"A Drawing document must be active for this code to work. Exiting."&lt;/SPAN&gt;, &lt;SPAN&gt;vbCritical&lt;/SPAN&gt;, &lt;SPAN&gt;""&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;oDDoc&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;DrawingDocument&lt;/SPAN&gt; = &lt;SPAN&gt;ThisDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Document&lt;/SPAN&gt;
	&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oSheets&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;Sheets&lt;/SPAN&gt; = &lt;SPAN&gt;oDDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Sheets&lt;/SPAN&gt;
	&lt;SPAN&gt;'get user input&lt;/SPAN&gt;
	&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;sTextToFind&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;InputBox&lt;/SPAN&gt;(&lt;SPAN&gt;"Enter Text To Find:"&lt;/SPAN&gt;, &lt;SPAN&gt;"iLogic"&lt;/SPAN&gt;, &lt;SPAN&gt;"XXX"&lt;/SPAN&gt;)
		&lt;SPAN&gt;'look for blank value&lt;/SPAN&gt;
		&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;sTextToFind&lt;/SPAN&gt; = &lt;SPAN&gt;""&lt;/SPAN&gt; &lt;SPAN&gt;Then&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;Dim&lt;/SPAN&gt; &lt;SPAN&gt;sTextToReplaceIt&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;InputBox&lt;/SPAN&gt;(&lt;SPAN&gt;"Enter Text To Replace   '"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;oTXT2Find&lt;/SPAN&gt; _
		&amp;amp; &lt;SPAN&gt;"'  with."&lt;/SPAN&gt;, &lt;SPAN&gt;"iLogic"&lt;/SPAN&gt;, &lt;SPAN&gt;"ZZZ"&lt;/SPAN&gt;)
		&lt;SPAN&gt;'look for blank value&lt;/SPAN&gt;
		&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;sTextToReplaceIt&lt;/SPAN&gt; = &lt;SPAN&gt;""&lt;/SPAN&gt; &lt;SPAN&gt;Then&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;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oSheet&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;Sheet&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oSheets&lt;/SPAN&gt;
		&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oCTables&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;CustomTables&lt;/SPAN&gt; = &lt;SPAN&gt;oSheet&lt;/SPAN&gt;.&lt;SPAN&gt;CustomTables&lt;/SPAN&gt;
		&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oCTables&lt;/SPAN&gt;.&lt;SPAN&gt;Count&lt;/SPAN&gt; = 0 &lt;SPAN&gt;Then&lt;/SPAN&gt; &lt;SPAN&gt;Continue&lt;/SPAN&gt; &lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;'skip to next oSheet in loop&lt;/SPAN&gt;
		&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oCTable&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;CustomTable&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oCTables&lt;/SPAN&gt;
			&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oCTable&lt;/SPAN&gt;.&lt;SPAN&gt;Title&lt;/SPAN&gt;.&lt;SPAN&gt;Contains&lt;/SPAN&gt;(&lt;SPAN&gt;sTextToFind&lt;/SPAN&gt;) &lt;SPAN&gt;Then&lt;/SPAN&gt;
				&lt;SPAN&gt;Try&lt;/SPAN&gt;
					&lt;SPAN&gt;oCTable&lt;/SPAN&gt;.&lt;SPAN&gt;Title&lt;/SPAN&gt; = &lt;SPAN&gt;oCTable&lt;/SPAN&gt;.&lt;SPAN&gt;Title&lt;/SPAN&gt;.&lt;SPAN&gt;Replace&lt;/SPAN&gt;(&lt;SPAN&gt;sTextToFind&lt;/SPAN&gt;, &lt;SPAN&gt;sTextToReplaceIt&lt;/SPAN&gt;)
				&lt;SPAN&gt;Catch&lt;/SPAN&gt;
					&lt;SPAN&gt;Logger&lt;/SPAN&gt;.&lt;SPAN&gt;Error&lt;/SPAN&gt;(&lt;SPAN&gt;"Error replacing text in Title of CustomTable"&lt;/SPAN&gt;)
				&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Try&lt;/SPAN&gt;
			&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;
			&lt;SPAN&gt;'&amp;lt;&amp;lt;&amp;lt; you can traverse the data in the table by rows or by columns &amp;gt;&amp;gt;&amp;gt;&lt;/SPAN&gt;
			&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oRows&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;Rows&lt;/SPAN&gt; = &lt;SPAN&gt;oCTable&lt;/SPAN&gt;.&lt;SPAN&gt;Rows&lt;/SPAN&gt;
			&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oRow&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;Row&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oRows&lt;/SPAN&gt;
				&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oCell&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;Cell&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oRow&lt;/SPAN&gt;
					&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oCell&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;.&lt;SPAN&gt;Contains&lt;/SPAN&gt;(&lt;SPAN&gt;sTextToFind&lt;/SPAN&gt;) &lt;SPAN&gt;Then&lt;/SPAN&gt;
						&lt;SPAN&gt;Try&lt;/SPAN&gt;
							&lt;SPAN&gt;oCell&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;oCell&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;.&lt;SPAN&gt;Replace&lt;/SPAN&gt;(&lt;SPAN&gt;sTextToFind&lt;/SPAN&gt;, &lt;SPAN&gt;sTextToReplaceIt&lt;/SPAN&gt;)
						&lt;SPAN&gt;Catch&lt;/SPAN&gt;
							&lt;SPAN&gt;Logger&lt;/SPAN&gt;.&lt;SPAN&gt;Error&lt;/SPAN&gt;(&lt;SPAN&gt;"Error replacing text in Cell of CustomTable"&lt;/SPAN&gt;)
						&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Try&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;'oCell&lt;/SPAN&gt;
			&lt;SPAN&gt;Next&lt;/SPAN&gt; &lt;SPAN&gt;'oRow&lt;/SPAN&gt;
		&lt;SPAN&gt;Next&lt;/SPAN&gt; &lt;SPAN&gt;'oCTable&lt;/SPAN&gt;
	&lt;SPAN&gt;Next&lt;/SPAN&gt; &lt;SPAN&gt;'oSheet&lt;/SPAN&gt;
	&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oDDoc&lt;/SPAN&gt;.&lt;SPAN&gt;RequiresUpdate&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt; &lt;SPAN&gt;oDDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Update2&lt;/SPAN&gt;(&lt;SPAN&gt;True&lt;/SPAN&gt;)
	&lt;SPAN&gt;'If oDDoc.Dirty Then oDDoc.Save2(False)&lt;/SPAN&gt;
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;Sub&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 14 Sep 2023 11:42:24 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/find-and-replace-text-in-custom-table-cells/m-p/12240036#M157703</guid>
      <dc:creator>martin.jerabekM5BZE</dc:creator>
      <dc:date>2023-09-14T11:42:24Z</dc:date>
    </item>
    <item>
      <title>Re: Find and replace text in Custom table cells</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/find-and-replace-text-in-custom-table-cells/m-p/12240039#M157704</link>
      <description>&lt;P&gt;I'm gonna assume you mean a Parts list when you say "list" or "&lt;SPAN&gt;Custom table"&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;here's my code to find the first parts list in a certain sheet, edit it, go over each cell in a certain row and edit that cell (if necessary)&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;happy coding!&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;edit: and I'm already too late, while I was typing there already was a solution posted, I love this community&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;sub main&lt;BR /&gt;call editpartslist&lt;BR /&gt;end sub&lt;BR /&gt;Sub&lt;/SPAN&gt; &lt;SPAN&gt;editpartslist&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;ThisDrawing&lt;/SPAN&gt;.&lt;SPAN&gt;Document&lt;/SPAN&gt;

&lt;SPAN&gt;' Set a reference to the first parts list on the selected sheet.&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oPartList&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;s&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt;
	&lt;SPAN&gt;s&lt;/SPAN&gt; = &lt;SPAN&gt;"Sheetname:1"&lt;/SPAN&gt;
	
&lt;SPAN&gt;On&lt;/SPAN&gt; &lt;SPAN&gt;Error&lt;/SPAN&gt; &lt;SPAN&gt;GoTo&lt;/SPAN&gt; &lt;SPAN&gt;sheetnotfound&lt;/SPAN&gt; :
	&lt;SPAN&gt;oPartList&lt;/SPAN&gt; = &lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Sheets&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(&lt;SPAN&gt;s&lt;/SPAN&gt;).&lt;SPAN&gt;PartsLists&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(1)
&lt;SPAN&gt;On&lt;/SPAN&gt; &lt;SPAN&gt;Error&lt;/SPAN&gt; &lt;SPAN&gt;GoTo&lt;/SPAN&gt; &lt;SPAN&gt;errorhandler&lt;/SPAN&gt; :
	

&lt;SPAN&gt;' Iterate through the contents of the parts list.&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;i&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Long&lt;/SPAN&gt;
&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;oPartList&lt;/SPAN&gt;.&lt;SPAN&gt;PartsListRows&lt;/SPAN&gt;.&lt;SPAN&gt;Count&lt;/SPAN&gt;
&lt;SPAN&gt;'look at only the QTY column&lt;/SPAN&gt;
&lt;SPAN&gt;oCell&lt;/SPAN&gt; = &lt;SPAN&gt;oPartList&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;"QTY"&lt;/SPAN&gt;)

&lt;SPAN&gt;'reset static values&lt;/SPAN&gt;
&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oCell&lt;/SPAN&gt;.&lt;SPAN&gt;Static&lt;/SPAN&gt; = &lt;SPAN&gt;True&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt; &lt;SPAN&gt;oCell&lt;/SPAN&gt;.&lt;SPAN&gt;Static&lt;/SPAN&gt; = &lt;SPAN&gt;False&lt;/SPAN&gt;
&lt;SPAN&gt;'do stuff in the cells&lt;/SPAN&gt;
	&lt;SPAN&gt;v&lt;/SPAN&gt; = &lt;SPAN&gt;oCell&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;
	&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;v&lt;/SPAN&gt;.&lt;SPAN&gt;Contains&lt;/SPAN&gt;(&lt;SPAN&gt;"mm"&lt;/SPAN&gt;) &lt;SPAN&gt;Or&lt;/SPAN&gt; &lt;SPAN&gt;v&lt;/SPAN&gt;.&lt;SPAN&gt;Contains&lt;/SPAN&gt;(&lt;SPAN&gt;","&lt;/SPAN&gt;)
		&lt;SPAN&gt;oCell&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt; = &lt;SPAN&gt;Ceil&lt;/SPAN&gt;(&lt;SPAN&gt;Val&lt;/SPAN&gt;(&lt;SPAN&gt;Replace&lt;/SPAN&gt;(&lt;SPAN&gt;v&lt;/SPAN&gt;, &lt;SPAN&gt;","&lt;/SPAN&gt;, &lt;SPAN&gt;"."&lt;/SPAN&gt;)))
	&lt;SPAN&gt;Else&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;Exit&lt;/SPAN&gt; &lt;SPAN&gt;Sub&lt;/SPAN&gt;
&lt;SPAN&gt;'errorhandling&lt;/SPAN&gt;
&lt;SPAN&gt;sheetnotfound&lt;/SPAN&gt; : &lt;SPAN&gt;MessageBox&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;"sheet named "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;s&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;" not found while editing partslist"&lt;/SPAN&gt;) : &lt;SPAN&gt;Exit&lt;/SPAN&gt; &lt;SPAN&gt;Sub&lt;/SPAN&gt;
&lt;SPAN&gt;errorhandler&lt;/SPAN&gt; : &lt;SPAN&gt;MessageBox&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;"error while editing partslist"&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;Sub&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 14 Sep 2023 11:45:17 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/find-and-replace-text-in-custom-table-cells/m-p/12240039#M157704</guid>
      <dc:creator>Jacob__with__a__k</dc:creator>
      <dc:date>2023-09-14T11:45:17Z</dc:date>
    </item>
    <item>
      <title>Re: Find and replace text in Custom table cells</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/find-and-replace-text-in-custom-table-cells/m-p/12240199#M157717</link>
      <description>&lt;P&gt;Thank you for your reply. I do actually mean a "Custom table". For a Part lists I do not normaly overwrite cell value and it is driven by iProperty. But a Custom table is generated by an addon and I don't want to refresh complete lists, as it refreshes also the model views and delete cross-section and detail views.&lt;/P&gt;</description>
      <pubDate>Thu, 14 Sep 2023 12:36:45 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/find-and-replace-text-in-custom-table-cells/m-p/12240199#M157717</guid>
      <dc:creator>martin.jerabekM5BZE</dc:creator>
      <dc:date>2023-09-14T12:36:45Z</dc:date>
    </item>
  </channel>
</rss>

