<?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: Title Block Link to Excel to Update Single Sheet in Multi-Sheet IDW in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/title-block-link-to-excel-to-update-single-sheet-in-multi-sheet/m-p/13177186#M174372</link>
    <description>&lt;P&gt;If each sheet has different information,you couldn’t use the property of idw file.&lt;/P&gt;&lt;P&gt;it maybe a way to change or set properties for every sheet’s first view referenced model file.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 27 Nov 2024 11:34:24 GMT</pubDate>
    <dc:creator>Stakin</dc:creator>
    <dc:date>2024-11-27T11:34:24Z</dc:date>
    <item>
      <title>Title Block Link to Excel to Update Single Sheet in Multi-Sheet IDW</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/title-block-link-to-excel-to-update-single-sheet-in-multi-sheet/m-p/13173737#M174316</link>
      <description>&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;my company is toying with the idea of using multi-sheet drawings for assembly (and sometimes multi-assembly) jobs.&lt;/P&gt;&lt;P&gt;Currently I've got some code working that will update the title &amp;amp; revision block (all custom iprops) of a single-sheet IDW. Trouble is, i cant adapt this code to work for a multi-sheet drawing file. I've been scouring the forums trying to find any relevant code to help, but the issue is the same. Running the rule updates ALL the title blocks in the sheet-set, as opposed to just the active sheet which is what I need.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Any help would be greatly appreciated.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Please see below for the current working code for a single-sheet IDW file:&lt;/P&gt;&lt;P&gt;I've also attached a dummy excel file for any testing&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;StrNum&lt;/SPAN&gt; = &lt;SPAN&gt;InputBox&lt;/SPAN&gt;(&lt;SPAN&gt;"Please enter the JMG DRAWING NUMBER"&lt;/SPAN&gt;, &lt;SPAN&gt;"titty block"&lt;/SPAN&gt;)

&lt;SPAN&gt;I&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;FindRow&lt;/SPAN&gt;(&lt;SPAN&gt;"S:\A - DRAWINGS\DRAFTING from 2022\DRAWING REGISTER\Inventor Registers\HVO inventor.xlsm.xlsx"&lt;/SPAN&gt;, &lt;SPAN&gt;"sheet1"&lt;/SPAN&gt;, &lt;SPAN&gt;"JMG DRAWING NUMBER"&lt;/SPAN&gt;, &lt;SPAN&gt;"-"&lt;/SPAN&gt;, &lt;SPAN&gt;StrNum&lt;/SPAN&gt;)
&lt;SPAN&gt;StrTitle&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Title"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrCompany&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Company"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrDesc&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Description"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrProject&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Project"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRevisionNumber&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Register Revision Number"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrJMGDrawingNumber&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"JMG DRAWING NUMBER"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrClientDrawingNumber&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"CLIENT DRAWING NUMBER"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRevNoLine1&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"REF DRAWING NUMBER LINE 1"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRevDesLine1&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"REF DRAWING DESCRIPTION LINE 1"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRevNoLine2&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"REF DRAWING NUMBER LINE 2"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRevDesLine2&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"REF DRAWING DESCRIPTION LINE 2"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRevNoLine3&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"REF DRAWING NUMBER LINE 3"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRevDesLine3&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"REF DRAWING DESCRIPTION LINE 3"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRevNoLine4&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"REF DRAWING NUMBER LINE 4"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRevDesLine4&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"REF DRAWING DESCRIPTION LINE 4"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRevNoLine5&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"REF DRAWING NUMBER LINE 5"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRevDesLine5&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"REF DRAWING DESCRIPTION LINE 5"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefDesLine1&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L1 Description"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefAppLine1&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L1 Approved"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefByLine1&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L1 By"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefNoLine1&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L1 Number"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrDateLine1&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L1 Date"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefDesLine2&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L2 Description"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefAppLine2&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L2 Approved"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefByLine2&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L2 By"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefNoLine2&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L2 Number"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrDateLine2&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L2 Date"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefDesLine3&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L3 Description"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefAppLine3&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L3 Approved"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefByLine3&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L3 By"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrDateLine3&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L3 Date"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefNoLine3&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L3 Number"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefDesLine4&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L4 Description"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefAppLine4&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L4 Approved"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefByLine4&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L4 By"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefNoLine4&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L4 Number"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrDateLine4&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L4 Date"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefDesLine5&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L5 Description"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefAppLine5&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L5 Approved"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefByLine5&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L5 By"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefNoLine5&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L5 Number"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrDateLine5&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L5 Date"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefDesLine6&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L6 Description"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefAppLine6&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L6 Approved"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefByLine6&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L6 By"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrRefNoLine6&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L6 Number"&lt;/SPAN&gt;)
&lt;SPAN&gt;StrDateLine6&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CurrentRowValue&lt;/SPAN&gt;(&lt;SPAN&gt;"Rev L6 Date"&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;"Drawing Number"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrNum&lt;/SPAN&gt;
&lt;SPAN&gt;iProperties&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;(&lt;SPAN&gt;"Summary"&lt;/SPAN&gt;, &lt;SPAN&gt;"Title"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrTitle&lt;/SPAN&gt;
&lt;SPAN&gt;iProperties&lt;/SPAN&gt;.&lt;SPAN&gt;Value&lt;/SPAN&gt;(&lt;SPAN&gt;"Summary"&lt;/SPAN&gt;, &lt;SPAN&gt;"Company"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrCompany&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;"Description"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrDesc&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;"Project"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrProject&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;"JMG DRAWING NUMBER"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrJMGDrawingNumber&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;StrClientDrawingNumber&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;"Revision Number"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRevisionNumber&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;"REF DRAWING NUMBER LINE 1"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRevNoLine1&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;"REF DRAWING DESCRIPTION LINE 1"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRevDesLine1&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;"REF DRAWING NUMBER LINE 2"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRevNoLine2&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;"REF DRAWING DESCRIPTION LINE 2"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRevDesLine2&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;"REF DRAWING NUMBER LINE 3"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRevNoLine3&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;"REF DRAWING DESCRIPTION LINE 3"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRevDesLine3&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;"REF DRAWING NUMBER LINE 4"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRevNoLine4&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;"REF DRAWING DESCRIPTION LINE 4"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRevDesLine4&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;"REF DRAWING NUMBER LINE 5"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRevNoLine5&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;"REF DRAWING DESCRIPTION LINE 5"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRevDesLine5&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;"Rev L1 Description"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefDesLine1&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;"Rev L1 Approved"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefAppLine1&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;"Rev L1 By"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefByLine1&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;"Rev L1 Number"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefNoLine1&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;"Rev L1 Date"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrDateLine1&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;"Rev L2 Description"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefDesLine2&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;"Rev L2 Approved"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefAppLine2&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;"Rev L2 By"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefByLine2&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;"Rev L2 Number"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefNoLine2&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;"Rev L2 Date"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrDateLine2&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;"Rev L3 Description"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefDesLine3&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;"Rev L3 Approved"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefAppLine3&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;"Rev L3 By"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefByLine3&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;"Rev L3 Number"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefNoLine3&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;"Rev L3 Date"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrDateLine3&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;"Rev L4 Description"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefDesLine4&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;"Rev L4 Approved"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefAppLine4&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;"Rev L4 By"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefByLine4&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;"Rev L4 Number"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefNoLine4&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;"Rev L4 Date"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrDateLine4&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;"Rev L5 Description"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefDesLine5&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;"Rev L5 Approved"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefAppLine5&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;"Rev L5 By"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefByLine5&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;"Rev L5 Number"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefNoLine5&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;"Rev L5 Date"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrDateLine5&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;"Rev L6 Description"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefDesLine6&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;"Rev L6 Approved"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefAppLine6&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;"Rev L6 By"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefByLine6&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;"Rev L6 Number"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrRefNoLine6&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;"Rev L6 Date"&lt;/SPAN&gt;) = &lt;SPAN&gt;StrDateLine6&lt;/SPAN&gt;


&lt;SPAN&gt;MessageBox&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;"All properties have been applied to "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;StrNum&lt;/SPAN&gt;, &lt;SPAN&gt;"Success"&lt;/SPAN&gt;)&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 26 Nov 2024 03:16:13 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/title-block-link-to-excel-to-update-single-sheet-in-multi-sheet/m-p/13173737#M174316</guid>
      <dc:creator>drafting4KGWTN</dc:creator>
      <dc:date>2024-11-26T03:16:13Z</dc:date>
    </item>
    <item>
      <title>Betreff: Title Block Link to Excel to Update Single Sheet in Multi-Sheet IDW</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/title-block-link-to-excel-to-update-single-sheet-in-multi-sheet/m-p/13174758#M174340</link>
      <description>&lt;P&gt;Hello&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The titleblock on the sheet is just a reference to the titleblockdefinition. All titleblocks get the same informations. This is as designed. There is no way to update only one the way you try.&lt;/P&gt;&lt;P&gt;If you need different entries, you can either define a separate titleblockdefinition for each sheet and set custoim iProps according to each sheet. Or you use PromptedEntries instead iProp in your titleblock.&lt;/P&gt;</description>
      <pubDate>Tue, 26 Nov 2024 13:38:03 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/title-block-link-to-excel-to-update-single-sheet-in-multi-sheet/m-p/13174758#M174340</guid>
      <dc:creator>Ralf_Krieg</dc:creator>
      <dc:date>2024-11-26T13:38:03Z</dc:date>
    </item>
    <item>
      <title>Betreff: Title Block Link to Excel to Update Single Sheet in Multi-Sheet IDW</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/title-block-link-to-excel-to-update-single-sheet-in-multi-sheet/m-p/13175564#M174351</link>
      <description>&lt;P&gt;...our shop has too much variety to do custom iprops for every sheet. i'll have a look into the prompted entries you mentioned.&lt;BR /&gt;&lt;BR /&gt;thank you for the reply&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;EM&gt;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/16111693"&gt;@drafting4KGWTN&lt;/a&gt;&amp;nbsp;-this post has been edited due to &lt;A href="https://forums.autodesk.com/t5/forum-user-guides/community-rules-and-etiquette/td-p/9581007" target="_blank"&gt;Community Rules &amp;amp; Etiquette violation&lt;/A&gt;&lt;/EM&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 26 Nov 2024 19:38:07 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/title-block-link-to-excel-to-update-single-sheet-in-multi-sheet/m-p/13175564#M174351</guid>
      <dc:creator>drafting4KGWTN</dc:creator>
      <dc:date>2024-11-26T19:38:07Z</dc:date>
    </item>
    <item>
      <title>Re: Title Block Link to Excel to Update Single Sheet in Multi-Sheet IDW</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/title-block-link-to-excel-to-update-single-sheet-in-multi-sheet/m-p/13176227#M174361</link>
      <description>&lt;P&gt;I've been doing some digging today and found some code that does what i want. The only problem is, it loops through the prompt entries to each sheet in the IDW set.&lt;/P&gt;&lt;P&gt;after trial and error, i managed to alter the code so the loop stops after one sheet. But it'll only change the prompts on the 1st sheet - as opposed to the one that is active&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;please see below for both pieces of code&lt;/P&gt;&lt;P&gt;(code looping through each sheet)&lt;/P&gt;&lt;PRE&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;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;Sheet&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oSheets&lt;/SPAN&gt;
	&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oSheet&lt;/SPAN&gt;.&lt;SPAN&gt;TitleBlock&lt;/SPAN&gt; &lt;SPAN&gt;Is&lt;/SPAN&gt; &lt;SPAN&gt;Nothing&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt; &lt;SPAN&gt;Continue&lt;/SPAN&gt; &lt;SPAN&gt;For&lt;/SPAN&gt;
	&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oTB&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;TitleBlock&lt;/SPAN&gt; = &lt;SPAN&gt;oSheet&lt;/SPAN&gt;.&lt;SPAN&gt;TitleBlock&lt;/SPAN&gt;
	&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oSketch&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;DrawingSketch&lt;/SPAN&gt; = &lt;SPAN&gt;oTB&lt;/SPAN&gt;.&lt;SPAN&gt;Definition&lt;/SPAN&gt;.&lt;SPAN&gt;Sketch&lt;/SPAN&gt;
	&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oTBoxes&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;TextBoxes&lt;/SPAN&gt; = &lt;SPAN&gt;oSketch&lt;/SPAN&gt;.&lt;SPAN&gt;TextBoxes&lt;/SPAN&gt;
	&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oTBoxes&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;Dim&lt;/SPAN&gt; &lt;SPAN&gt;sP1&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;"&amp;lt;Prompt&amp;gt;"&lt;/SPAN&gt; : &lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;sP2&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;"&amp;lt;/Prompt&amp;gt;"&lt;/SPAN&gt;
	&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oTBox&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;TextBox&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oTBoxes&lt;/SPAN&gt;
		&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;Not&lt;/SPAN&gt; &lt;SPAN&gt;oTBox&lt;/SPAN&gt;.&lt;SPAN&gt;FormattedText&lt;/SPAN&gt;.&lt;SPAN&gt;Contains&lt;/SPAN&gt;(&lt;SPAN&gt;sP2&lt;/SPAN&gt;) &lt;SPAN&gt;Then&lt;/SPAN&gt; &lt;SPAN&gt;Continue&lt;/SPAN&gt; &lt;SPAN&gt;For&lt;/SPAN&gt;
		&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;sPrompt&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;oTBox&lt;/SPAN&gt;.&lt;SPAN&gt;Text&lt;/SPAN&gt;.&lt;SPAN&gt;Substring&lt;/SPAN&gt;(1, &lt;SPAN&gt;oTBox&lt;/SPAN&gt;.&lt;SPAN&gt;Text&lt;/SPAN&gt;.&lt;SPAN&gt;Length&lt;/SPAN&gt; - 2)
		&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;sCurVal&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;oTB&lt;/SPAN&gt;.&lt;SPAN&gt;GetResultText&lt;/SPAN&gt;(&lt;SPAN&gt;oTBox&lt;/SPAN&gt;)
		&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;sNewVal&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;sPrompt&lt;/SPAN&gt;, &lt;SPAN&gt;"Prompted Entry"&lt;/SPAN&gt;, &lt;SPAN&gt;sCurVal&lt;/SPAN&gt;)
		&lt;SPAN&gt;oTB&lt;/SPAN&gt;.&lt;SPAN&gt;SetPromptResultText&lt;/SPAN&gt;(&lt;SPAN&gt;oTBox&lt;/SPAN&gt;, &lt;SPAN&gt;sNewVal&lt;/SPAN&gt;)
	&lt;SPAN&gt;Next&lt;/SPAN&gt; &lt;SPAN&gt;'oTBox&lt;/SPAN&gt;

&lt;SPAN&gt;Next&lt;/SPAN&gt; &lt;SPAN&gt;'oSheet&lt;BR /&gt;&lt;/SPAN&gt;
&lt;/PRE&gt;&lt;P&gt;code terminating after 1st cycle (but only writing to 1st sheet)&lt;/P&gt;&lt;PRE&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;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;Sheet&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oSheets&lt;/SPAN&gt;
	&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oSheet&lt;/SPAN&gt;.&lt;SPAN&gt;TitleBlock&lt;/SPAN&gt; &lt;SPAN&gt;Is&lt;/SPAN&gt; &lt;SPAN&gt;Nothing&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt; &lt;SPAN&gt;Continue&lt;/SPAN&gt; &lt;SPAN&gt;For&lt;/SPAN&gt;
	&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oTB&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;TitleBlock&lt;/SPAN&gt; = &lt;SPAN&gt;oSheet&lt;/SPAN&gt;.&lt;SPAN&gt;TitleBlock&lt;/SPAN&gt;
	&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oSketch&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;DrawingSketch&lt;/SPAN&gt; = &lt;SPAN&gt;oTB&lt;/SPAN&gt;.&lt;SPAN&gt;Definition&lt;/SPAN&gt;.&lt;SPAN&gt;Sketch&lt;/SPAN&gt;
	&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oTBoxes&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;TextBoxes&lt;/SPAN&gt; = &lt;SPAN&gt;oSketch&lt;/SPAN&gt;.&lt;SPAN&gt;TextBoxes&lt;/SPAN&gt;
	&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oTBoxes&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;Dim&lt;/SPAN&gt; &lt;SPAN&gt;sP1&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;"&amp;lt;Prompt&amp;gt;"&lt;/SPAN&gt; : &lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;sP2&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;"&amp;lt;/Prompt&amp;gt;"&lt;/SPAN&gt;
	&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oTBox&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;TextBox&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oTBoxes&lt;/SPAN&gt;
		&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;Not&lt;/SPAN&gt; &lt;SPAN&gt;oTBox&lt;/SPAN&gt;.&lt;SPAN&gt;FormattedText&lt;/SPAN&gt;.&lt;SPAN&gt;Contains&lt;/SPAN&gt;(&lt;SPAN&gt;sP2&lt;/SPAN&gt;) &lt;SPAN&gt;Then&lt;/SPAN&gt; &lt;SPAN&gt;Continue&lt;/SPAN&gt; &lt;SPAN&gt;For&lt;/SPAN&gt;
		&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;sPrompt&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;oTBox&lt;/SPAN&gt;.&lt;SPAN&gt;Text&lt;/SPAN&gt;.&lt;SPAN&gt;Substring&lt;/SPAN&gt;(1, &lt;SPAN&gt;oTBox&lt;/SPAN&gt;.&lt;SPAN&gt;Text&lt;/SPAN&gt;.&lt;SPAN&gt;Length&lt;/SPAN&gt; - 2)
		&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;sCurVal&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;oTB&lt;/SPAN&gt;.&lt;SPAN&gt;GetResultText&lt;/SPAN&gt;(&lt;SPAN&gt;oTBox&lt;/SPAN&gt;)
		&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;sNewVal&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;sPrompt&lt;/SPAN&gt;, &lt;SPAN&gt;"Prompted Entry"&lt;/SPAN&gt;, &lt;SPAN&gt;sCurVal&lt;/SPAN&gt;)
		&lt;SPAN&gt;oTB&lt;/SPAN&gt;.&lt;SPAN&gt;SetPromptResultText&lt;/SPAN&gt;(&lt;SPAN&gt;oTBox&lt;/SPAN&gt;, &lt;SPAN&gt;sNewVal&lt;/SPAN&gt;)
	&lt;SPAN&gt;Next&lt;/SPAN&gt; &lt;SPAN&gt;'oTBox&lt;/SPAN&gt;

		&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oSheet&lt;/SPAN&gt; &lt;SPAN&gt;IsNot&lt;/SPAN&gt; &lt;SPAN&gt;oActiveSheet&lt;/SPAN&gt; &lt;SPAN&gt;Then&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;Next&lt;/SPAN&gt; &lt;SPAN&gt;'oSheet&lt;/SPAN&gt;
&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 27 Nov 2024 02:35:08 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/title-block-link-to-excel-to-update-single-sheet-in-multi-sheet/m-p/13176227#M174361</guid>
      <dc:creator>drafting4KGWTN</dc:creator>
      <dc:date>2024-11-27T02:35:08Z</dc:date>
    </item>
    <item>
      <title>Re: Title Block Link to Excel to Update Single Sheet in Multi-Sheet IDW</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/title-block-link-to-excel-to-update-single-sheet-in-multi-sheet/m-p/13176284#M174363</link>
      <description>&lt;P&gt;if you only need to change the Activesheet, better to just define oSheet as such instead of having a For Loop.&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;LI-CODE lang="general"&gt;Dim oSheet as Sheet  = oDDoc.ActiveSheet&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;And you would have to replace the previous oSheet For Loop's "Continue For" to, possibly, "Exit sub"&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 27 Nov 2024 03:44:43 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/title-block-link-to-excel-to-update-single-sheet-in-multi-sheet/m-p/13176284#M174363</guid>
      <dc:creator>jnowel</dc:creator>
      <dc:date>2024-11-27T03:44:43Z</dc:date>
    </item>
    <item>
      <title>Re: Title Block Link to Excel to Update Single Sheet in Multi-Sheet IDW</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/title-block-link-to-excel-to-update-single-sheet-in-multi-sheet/m-p/13177186#M174372</link>
      <description>&lt;P&gt;If each sheet has different information,you couldn’t use the property of idw file.&lt;/P&gt;&lt;P&gt;it maybe a way to change or set properties for every sheet’s first view referenced model file.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 27 Nov 2024 11:34:24 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/title-block-link-to-excel-to-update-single-sheet-in-multi-sheet/m-p/13177186#M174372</guid>
      <dc:creator>Stakin</dc:creator>
      <dc:date>2024-11-27T11:34:24Z</dc:date>
    </item>
  </channel>
</rss>

