<?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: How to add drawing iproperties from an excel? in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9918900#M118819</link>
    <description>&lt;P&gt;I don't know what error you get. My code works, but omits error handling for clarity.&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;You need registered Inventor correctly.&lt;/LI&gt;&lt;LI&gt;Opened file must exists.&lt;/LI&gt;&lt;LI&gt;Opened file can't be newer then registered Inventor&lt;/LI&gt;&lt;/UL&gt;</description>
    <pubDate>Sun, 06 Dec 2020 12:20:24 GMT</pubDate>
    <dc:creator>Michael.Navara</dc:creator>
    <dc:date>2020-12-06T12:20:24Z</dc:date>
    <item>
      <title>How to add drawing iproperties from an excel?</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9917198#M118809</link>
      <description>&lt;P&gt;I have a requirement to add iproperties (checked by, checked date, design state, etc.) for a list of drawings.&lt;/P&gt;&lt;P&gt;I want to add these iproperties in Inventor from an excel using vba macros.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Please help me to create an excel vab macro to control Inventor and perform the above operations automatically.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Mohammed Shuaib K&lt;/P&gt;</description>
      <pubDate>Sat, 05 Dec 2020 08:00:22 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9917198#M118809</guid>
      <dc:creator>shuaib_cad</dc:creator>
      <dc:date>2020-12-05T08:00:22Z</dc:date>
    </item>
    <item>
      <title>Re: How to add drawing iproperties from an excel?</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9917357#M118810</link>
      <description>&lt;P&gt;For this task is better to start from Excel VBA. You can add reference to "Inventor Object Library" and then you can use Inventor.ApprenticeServer for writing data to iProperties. Apprentice has the best performance for this tasks.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Excel VBA example:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="general"&gt;Sub WriteData()
    Dim appServer As Inventor.ApprenticeServerComponent
    Set appServer = New ApprenticeServerComponent
    
    Dim oSheet As Worksheet
    Set oSheet = ThisWorkbook.ActiveSheet
    
    For i = 2 To 3
        
        Dim file As String
        Dim checkedBy As String
        Dim checkedDate As Date
        
        file = oSheet.Range("A" &amp;amp; i).Value
        checkedBy = oSheet.Range("B" &amp;amp; i).Value
        checkedDate = oSheet.Range("C" &amp;amp; i).Value
        
        Dim invDoc As Inventor.ApprenticeServerDocument
        Set invDoc = appServer.Open(file)
        
        invDoc.PropertySets("{32853F0F-3444-11D1-9E93-0060B03C1CA6}")("Checked By").Value = checkedBy
        invDoc.PropertySets("{32853F0F-3444-11D1-9E93-0060B03C1CA6}")("Date Checked").Value = checkedDate
        
        invDoc.PropertySets.FlushToFile
        invDoc.Close
        
    Next
    
End Sub&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Test data preview:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Test data preview" style="width: 372px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/852501iC4FAB9BDF341CDEF/image-size/large?v=v2&amp;amp;px=999" role="button" title="2020-12-05_11-51-46.png" alt="Test data preview" /&gt;&lt;span class="lia-inline-image-caption" onclick="event.preventDefault();"&gt;Test data preview&lt;/span&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Add reference to Inventor in Excel VBA&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="2020-12-05_11-34-13.png" style="width: 445px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/852500i291140F740A1F987/image-size/large?v=v2&amp;amp;px=999" role="button" title="2020-12-05_11-34-13.png" alt="2020-12-05_11-34-13.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 05 Dec 2020 10:58:16 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9917357#M118810</guid>
      <dc:creator>Michael.Navara</dc:creator>
      <dc:date>2020-12-05T10:58:16Z</dc:date>
    </item>
    <item>
      <title>Re: How to add drawing iproperties from an excel?</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9918131#M118814</link>
      <description>&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shuaib_cad_0-1607201265021.png" style="width: 400px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/852686iC43BE66F4D82280B/image-size/medium?v=v2&amp;amp;px=400" role="button" title="shuaib_cad_0-1607201265021.png" alt="shuaib_cad_0-1607201265021.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 05 Dec 2020 20:48:04 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9918131#M118814</guid>
      <dc:creator>shuaib_cad</dc:creator>
      <dc:date>2020-12-05T20:48:04Z</dc:date>
    </item>
    <item>
      <title>Re: How to add drawing iproperties from an excel?</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9918611#M118816</link>
      <description>&lt;P&gt;Getting the above error while running the code?&lt;/P&gt;&lt;P&gt;Please help me fix this issue.&lt;/P&gt;</description>
      <pubDate>Sun, 06 Dec 2020 06:31:24 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9918611#M118816</guid>
      <dc:creator>shuaib_cad</dc:creator>
      <dc:date>2020-12-06T06:31:24Z</dc:date>
    </item>
    <item>
      <title>Re: How to add drawing iproperties from an excel?</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9918900#M118819</link>
      <description>&lt;P&gt;I don't know what error you get. My code works, but omits error handling for clarity.&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;You need registered Inventor correctly.&lt;/LI&gt;&lt;LI&gt;Opened file must exists.&lt;/LI&gt;&lt;LI&gt;Opened file can't be newer then registered Inventor&lt;/LI&gt;&lt;/UL&gt;</description>
      <pubDate>Sun, 06 Dec 2020 12:20:24 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9918900#M118819</guid>
      <dc:creator>Michael.Navara</dc:creator>
      <dc:date>2020-12-06T12:20:24Z</dc:date>
    </item>
    <item>
      <title>Re: How to add drawing iproperties from an excel?</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9920325#M118833</link>
      <description>&lt;P&gt;hello &lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/1104556"&gt;@Michael.Navara&lt;/a&gt;&amp;nbsp;&lt;BR /&gt;could you tell me where is the VBA Project - References tab is located. thank you&lt;/P&gt;</description>
      <pubDate>Mon, 07 Dec 2020 09:29:58 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9920325#M118833</guid>
      <dc:creator>JonnyPot</dc:creator>
      <dc:date>2020-12-07T09:29:58Z</dc:date>
    </item>
    <item>
      <title>Re: How to add drawing iproperties from an excel?</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9920427#M118837</link>
      <description>&lt;P&gt;Full example is in attachment. Extract files to C:\Temp\*.*&lt;/P&gt;&lt;P&gt;Open "Data.xlsm" and included VBA project.&lt;/P&gt;&lt;P&gt;References tab is located here:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2020-12-07_11-38-51.png" style="width: 522px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/853013i5B6ACC5E99CFFF68/image-size/large?v=v2&amp;amp;px=999" role="button" title="2020-12-07_11-38-51.png" alt="2020-12-07_11-38-51.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 07 Dec 2020 10:41:26 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9920427#M118837</guid>
      <dc:creator>Michael.Navara</dc:creator>
      <dc:date>2020-12-07T10:41:26Z</dc:date>
    </item>
    <item>
      <title>Re: How to add drawing iproperties from an excel?</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9920466#M118838</link>
      <description>&lt;P&gt;Thank you&amp;nbsp;&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>Mon, 07 Dec 2020 11:14:02 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/9920466#M118838</guid>
      <dc:creator>JonnyPot</dc:creator>
      <dc:date>2020-12-07T11:14:02Z</dc:date>
    </item>
    <item>
      <title>Re: How to add drawing iproperties from an excel?</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/10107050#M121284</link>
      <description>&lt;P&gt;Hi Bro,&lt;/P&gt;&lt;P&gt;When i want to change from "checked by" to other one or use custome properties, how can i do?&lt;/P&gt;&lt;P&gt;Many thank&lt;/P&gt;</description>
      <pubDate>Wed, 24 Feb 2021 04:17:38 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/how-to-add-drawing-iproperties-from-an-excel/m-p/10107050#M121284</guid>
      <dc:creator>quangnguyen2FWX7</dc:creator>
      <dc:date>2021-02-24T04:17:38Z</dc:date>
    </item>
  </channel>
</rss>

