<?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 Thumbnail when export parts List in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/thumbnail-when-export-parts-list/m-p/9880308#M118299</link>
    <description>&lt;P&gt;Hello All,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have these ilogic code to export parts list to a excel file with some configuration, but i like export also a part thumbnail. what I need change in that code?&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;Code:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;'get the path and name of the drawing file&lt;BR /&gt;path_and_name = ThisDoc.PathAndFileName(False) ' without extension&lt;/P&gt;&lt;P&gt;'get PDF target folder path&lt;BR /&gt;ooFolder = ThisDoc.PathAndFileName&lt;/P&gt;&lt;P&gt;'Check for the PDF folder and create it if it does not exist&lt;BR /&gt;If Not System.IO.Directory.Exists(ooFolder) Then&lt;BR /&gt;System.IO.Directory.CreateDirectory(ooFolder)&lt;BR /&gt;End If&lt;/P&gt;&lt;P&gt;'define oDoc&lt;BR /&gt;oDoc = ThisDoc.Document&lt;/P&gt;&lt;P&gt;'specify the drawing sheet&lt;BR /&gt;'oSheet = oDoc.Sheets("Sheet:1") ' sheet by name&lt;BR /&gt;oSheet = oDoc.Sheets(1) ' first sheet&lt;/P&gt;&lt;P&gt;'say there is a Partslist on the sheet.&lt;BR /&gt;oPartslist = oSheet.PartsLists(1)&lt;BR /&gt;&lt;BR /&gt;'create a new NameValueMap object&lt;BR /&gt;oOptions = ThisApplication.TransientObjects.CreateNameValueMap&lt;/P&gt;&lt;P&gt;'specify an existing template file&lt;BR /&gt;'to use For formatting colors, fonts, etc&lt;BR /&gt;oOptions.Value("Template") = "C:\Users\LF\Desktop\Configuracoes Inventor LF\Templates\Lista_Pecas.xlsm"&lt;BR /&gt;&lt;BR /&gt;'specify the columns to export&lt;BR /&gt;oOptions.Value("ExportedColumns") = "PART NUMBER;DESCRIPTION;MATERIAL;COMPANY;QTY;WEBLINK;VENDOR"&lt;BR /&gt;&lt;BR /&gt;'specify the start cell&lt;BR /&gt;oOptions.Value("StartingCell") = "A3"&lt;BR /&gt;&lt;BR /&gt;'specify the XLS tab name&lt;BR /&gt;'here the file name is used&lt;BR /&gt;oOptions.Value("PARTS LIST") = ThisDoc.FileName(False) 'without extension&lt;/P&gt;&lt;P&gt;'choose to include the parts list title row&lt;BR /&gt;oOptions.Value("IncludeTitle") = False&lt;/P&gt;&lt;P&gt;'choose to autofit the column width in the xls file&lt;BR /&gt;oOptions.Value("AutoFitColumnWidth") = False&lt;/P&gt;&lt;P&gt;If Dir(ooFolder &amp;amp; ".xlsm") &amp;lt;&amp;gt; "" Then&lt;BR /&gt;Kill (ooFolder &amp;amp; ".xlsm")&lt;BR /&gt;End If&lt;/P&gt;&lt;P&gt;'get drawing name&lt;BR /&gt;oName = ThisDoc.FileName&lt;/P&gt;&lt;P&gt;' export the Partslist to Excel with options&lt;BR /&gt;oPartslist.Export(ooFolder &amp;amp; "\" &amp;amp; oName &amp;amp; ".xlsm",PartsListFileFormatEnum.kMicrosoftExcel, oOptions)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Thu, 19 Nov 2020 08:59:41 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2020-11-19T08:59:41Z</dc:date>
    <item>
      <title>Thumbnail when export parts List</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/thumbnail-when-export-parts-list/m-p/9880308#M118299</link>
      <description>&lt;P&gt;Hello All,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have these ilogic code to export parts list to a excel file with some configuration, but i like export also a part thumbnail. what I need change in that code?&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;Code:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;'get the path and name of the drawing file&lt;BR /&gt;path_and_name = ThisDoc.PathAndFileName(False) ' without extension&lt;/P&gt;&lt;P&gt;'get PDF target folder path&lt;BR /&gt;ooFolder = ThisDoc.PathAndFileName&lt;/P&gt;&lt;P&gt;'Check for the PDF folder and create it if it does not exist&lt;BR /&gt;If Not System.IO.Directory.Exists(ooFolder) Then&lt;BR /&gt;System.IO.Directory.CreateDirectory(ooFolder)&lt;BR /&gt;End If&lt;/P&gt;&lt;P&gt;'define oDoc&lt;BR /&gt;oDoc = ThisDoc.Document&lt;/P&gt;&lt;P&gt;'specify the drawing sheet&lt;BR /&gt;'oSheet = oDoc.Sheets("Sheet:1") ' sheet by name&lt;BR /&gt;oSheet = oDoc.Sheets(1) ' first sheet&lt;/P&gt;&lt;P&gt;'say there is a Partslist on the sheet.&lt;BR /&gt;oPartslist = oSheet.PartsLists(1)&lt;BR /&gt;&lt;BR /&gt;'create a new NameValueMap object&lt;BR /&gt;oOptions = ThisApplication.TransientObjects.CreateNameValueMap&lt;/P&gt;&lt;P&gt;'specify an existing template file&lt;BR /&gt;'to use For formatting colors, fonts, etc&lt;BR /&gt;oOptions.Value("Template") = "C:\Users\LF\Desktop\Configuracoes Inventor LF\Templates\Lista_Pecas.xlsm"&lt;BR /&gt;&lt;BR /&gt;'specify the columns to export&lt;BR /&gt;oOptions.Value("ExportedColumns") = "PART NUMBER;DESCRIPTION;MATERIAL;COMPANY;QTY;WEBLINK;VENDOR"&lt;BR /&gt;&lt;BR /&gt;'specify the start cell&lt;BR /&gt;oOptions.Value("StartingCell") = "A3"&lt;BR /&gt;&lt;BR /&gt;'specify the XLS tab name&lt;BR /&gt;'here the file name is used&lt;BR /&gt;oOptions.Value("PARTS LIST") = ThisDoc.FileName(False) 'without extension&lt;/P&gt;&lt;P&gt;'choose to include the parts list title row&lt;BR /&gt;oOptions.Value("IncludeTitle") = False&lt;/P&gt;&lt;P&gt;'choose to autofit the column width in the xls file&lt;BR /&gt;oOptions.Value("AutoFitColumnWidth") = False&lt;/P&gt;&lt;P&gt;If Dir(ooFolder &amp;amp; ".xlsm") &amp;lt;&amp;gt; "" Then&lt;BR /&gt;Kill (ooFolder &amp;amp; ".xlsm")&lt;BR /&gt;End If&lt;/P&gt;&lt;P&gt;'get drawing name&lt;BR /&gt;oName = ThisDoc.FileName&lt;/P&gt;&lt;P&gt;' export the Partslist to Excel with options&lt;BR /&gt;oPartslist.Export(ooFolder &amp;amp; "\" &amp;amp; oName &amp;amp; ".xlsm",PartsListFileFormatEnum.kMicrosoftExcel, oOptions)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 19 Nov 2020 08:59:41 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/thumbnail-when-export-parts-list/m-p/9880308#M118299</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2020-11-19T08:59:41Z</dc:date>
    </item>
  </channel>
</rss>

