<?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 Import/replace embedded .xlsx file through form built with iLogic in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/import-replace-embedded-xlsx-file-through-form-built-with-ilogic/m-p/11668938#M147591</link>
    <description>&lt;P&gt;Hi, I have created a rule inside a simple part drawing that lets you open a filebrowser inside a form. The code looks like this:&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;'present a File Selection dialog&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oFileDlg&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;FileDialog&lt;/SPAN&gt; = &lt;SPAN&gt;Nothing&lt;/SPAN&gt;
&lt;SPAN&gt;InventorVb&lt;/SPAN&gt;.&lt;SPAN&gt;Application&lt;/SPAN&gt;.&lt;SPAN&gt;CreateFileDialog&lt;/SPAN&gt;(&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;)
&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;InitialDirectory&lt;/SPAN&gt; = &lt;SPAN&gt;oOrigRefName&lt;/SPAN&gt;
&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;Filter&lt;/SPAN&gt; = &lt;SPAN&gt;"Excel Spec Sheet(*.xlsx)|*.xlsx"&lt;/SPAN&gt;
&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;CancelError&lt;/SPAN&gt; = &lt;SPAN&gt;True&lt;/SPAN&gt;
&lt;SPAN&gt;On&lt;/SPAN&gt; &lt;SPAN&gt;Error&lt;/SPAN&gt; &lt;SPAN&gt;Resume&lt;/SPAN&gt; &lt;SPAN&gt;Next&lt;/SPAN&gt;
&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;ShowOpen&lt;/SPAN&gt;()
&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;Err&lt;/SPAN&gt;.&lt;SPAN&gt;Number&lt;/SPAN&gt; &amp;lt;&amp;gt; 0 &lt;SPAN&gt;Then&lt;/SPAN&gt;
&lt;SPAN&gt;Return&lt;/SPAN&gt;
&lt;SPAN&gt;ElseIf&lt;/SPAN&gt; &lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;FileName&lt;/SPAN&gt; &amp;lt;&amp;gt; &lt;SPAN&gt;""&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt;
&lt;SPAN&gt;selectedfile&lt;/SPAN&gt; = &lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;FileName&lt;/SPAN&gt;
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;

&lt;SPAN&gt;MessageBox&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;"You selected: "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;selectedfile&lt;/SPAN&gt; , &lt;SPAN&gt;"iLogic"&lt;/SPAN&gt;)&lt;/PRE&gt;&lt;P&gt;at its current stage, the form is very simple, and only includes an image as Banner, and the mentioned code.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="op_thorsager_0-1673355838835.png" style="width: 600px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1160750i99C7AD81FF3EC767/image-size/medium?v=v2&amp;amp;px=400" role="button" title="op_thorsager_0-1673355838835.png" alt="op_thorsager_0-1673355838835.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;The form looks as shown above.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;everything works as inteded, and i know its only displaying an explorer in which you can select a file you want to use. What i want it to do is have it embed the file selected, as the inteded use of the tool im working on, is to have a standardized spreadsheet layout with necessary parameters defined within. The reason why i'm not using a spreadsheet link for this, is due to functionality, as the final product is gonna be used internally on an international scale.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The reason i want it to embed/replace the currently embedded spreadsheet, is so that a non inventor user can fill out the spreadsheet template i've made, send it to one of our engineers, who will then use the form and define the filepath for the received spec sheet.&amp;nbsp;&lt;/P&gt;&lt;P&gt;what is the most convenient approach to this setup?&amp;nbsp;&lt;/P&gt;&lt;P&gt;the file you import through the form will define the parameters inside the assembly, and update dimensions accordingly.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;My thought would be to have a "default" setup spreadsheet embedded inside the assembly, which functions as a dummy. when our engineer receives a specsheet, or updates a specsheet, they will then use the form to define filepath to the new and updated sheet with new parametric values, but with the same name definitions as the dummy sheet. After selecting the path of the updated specsheet, i want it to replace the currently embedded dummy sheet, but keep the same parameter names, so that it doesn't end up just adding a copy of the already added sheet parameters.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I don't know what would be the best solution to this, or if it's even possible to do what i want it to do.&amp;nbsp;&lt;/P&gt;&lt;P&gt;Alternatively i guess i could make a spreadsheet setup, which looks identical to an exported XML file from the parameter window inside Inventor - that way would just need to write an iLogic rule which functions as an "import XML" button.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Any recommendations regarding which solution would work in my case? The currently used code does not import anything from the file selected through the form - i'm slowly testing my way through all of this, as i'm very new to all of this iLogic and VB setup.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I hope my description of what i'm trying to do is sufficient. If not, feel free to ask &lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@B4D44A73814D7FC0D950DEDFACB97081/emoticons/1f642.png" alt=":slightly_smiling_face:" title=":slightly_smiling_face:" /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 10 Jan 2023 13:20:08 GMT</pubDate>
    <dc:creator>op_thorsager</dc:creator>
    <dc:date>2023-01-10T13:20:08Z</dc:date>
    <item>
      <title>Import/replace embedded .xlsx file through form built with iLogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/import-replace-embedded-xlsx-file-through-form-built-with-ilogic/m-p/11668938#M147591</link>
      <description>&lt;P&gt;Hi, I have created a rule inside a simple part drawing that lets you open a filebrowser inside a form. The code looks like this:&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;'present a File Selection dialog&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oFileDlg&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;FileDialog&lt;/SPAN&gt; = &lt;SPAN&gt;Nothing&lt;/SPAN&gt;
&lt;SPAN&gt;InventorVb&lt;/SPAN&gt;.&lt;SPAN&gt;Application&lt;/SPAN&gt;.&lt;SPAN&gt;CreateFileDialog&lt;/SPAN&gt;(&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;)
&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;InitialDirectory&lt;/SPAN&gt; = &lt;SPAN&gt;oOrigRefName&lt;/SPAN&gt;
&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;Filter&lt;/SPAN&gt; = &lt;SPAN&gt;"Excel Spec Sheet(*.xlsx)|*.xlsx"&lt;/SPAN&gt;
&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;CancelError&lt;/SPAN&gt; = &lt;SPAN&gt;True&lt;/SPAN&gt;
&lt;SPAN&gt;On&lt;/SPAN&gt; &lt;SPAN&gt;Error&lt;/SPAN&gt; &lt;SPAN&gt;Resume&lt;/SPAN&gt; &lt;SPAN&gt;Next&lt;/SPAN&gt;
&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;ShowOpen&lt;/SPAN&gt;()
&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;Err&lt;/SPAN&gt;.&lt;SPAN&gt;Number&lt;/SPAN&gt; &amp;lt;&amp;gt; 0 &lt;SPAN&gt;Then&lt;/SPAN&gt;
&lt;SPAN&gt;Return&lt;/SPAN&gt;
&lt;SPAN&gt;ElseIf&lt;/SPAN&gt; &lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;FileName&lt;/SPAN&gt; &amp;lt;&amp;gt; &lt;SPAN&gt;""&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt;
&lt;SPAN&gt;selectedfile&lt;/SPAN&gt; = &lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;FileName&lt;/SPAN&gt;
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;

&lt;SPAN&gt;MessageBox&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;"You selected: "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;selectedfile&lt;/SPAN&gt; , &lt;SPAN&gt;"iLogic"&lt;/SPAN&gt;)&lt;/PRE&gt;&lt;P&gt;at its current stage, the form is very simple, and only includes an image as Banner, and the mentioned code.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="op_thorsager_0-1673355838835.png" style="width: 600px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1160750i99C7AD81FF3EC767/image-size/medium?v=v2&amp;amp;px=400" role="button" title="op_thorsager_0-1673355838835.png" alt="op_thorsager_0-1673355838835.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;The form looks as shown above.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;everything works as inteded, and i know its only displaying an explorer in which you can select a file you want to use. What i want it to do is have it embed the file selected, as the inteded use of the tool im working on, is to have a standardized spreadsheet layout with necessary parameters defined within. The reason why i'm not using a spreadsheet link for this, is due to functionality, as the final product is gonna be used internally on an international scale.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The reason i want it to embed/replace the currently embedded spreadsheet, is so that a non inventor user can fill out the spreadsheet template i've made, send it to one of our engineers, who will then use the form and define the filepath for the received spec sheet.&amp;nbsp;&lt;/P&gt;&lt;P&gt;what is the most convenient approach to this setup?&amp;nbsp;&lt;/P&gt;&lt;P&gt;the file you import through the form will define the parameters inside the assembly, and update dimensions accordingly.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;My thought would be to have a "default" setup spreadsheet embedded inside the assembly, which functions as a dummy. when our engineer receives a specsheet, or updates a specsheet, they will then use the form to define filepath to the new and updated sheet with new parametric values, but with the same name definitions as the dummy sheet. After selecting the path of the updated specsheet, i want it to replace the currently embedded dummy sheet, but keep the same parameter names, so that it doesn't end up just adding a copy of the already added sheet parameters.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I don't know what would be the best solution to this, or if it's even possible to do what i want it to do.&amp;nbsp;&lt;/P&gt;&lt;P&gt;Alternatively i guess i could make a spreadsheet setup, which looks identical to an exported XML file from the parameter window inside Inventor - that way would just need to write an iLogic rule which functions as an "import XML" button.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Any recommendations regarding which solution would work in my case? The currently used code does not import anything from the file selected through the form - i'm slowly testing my way through all of this, as i'm very new to all of this iLogic and VB setup.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I hope my description of what i'm trying to do is sufficient. If not, feel free to ask &lt;img class="lia-deferred-image lia-image-emoji" src="https://forums.autodesk.com/html/@B4D44A73814D7FC0D950DEDFACB97081/emoticons/1f642.png" alt=":slightly_smiling_face:" title=":slightly_smiling_face:" /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 10 Jan 2023 13:20:08 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/import-replace-embedded-xlsx-file-through-form-built-with-ilogic/m-p/11668938#M147591</guid>
      <dc:creator>op_thorsager</dc:creator>
      <dc:date>2023-01-10T13:20:08Z</dc:date>
    </item>
    <item>
      <title>Re: Import/replace embedded .xlsx file through form built with iLogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/import-replace-embedded-xlsx-file-through-form-built-with-ilogic/m-p/11669313#M147600</link>
      <description>&lt;P&gt;There is likely no need to import/ embed the excel sheet. Based on your previous method to import the iproperties from the excel file using go excel. As long as the excel file is located in the same folder as the inventor document and you have defined the name of the file then go excel function will find the excel file.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Filename only&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Open&lt;/SPAN&gt;(&lt;SPAN&gt;"dwg-param.xlsx"&lt;/SPAN&gt;, &lt;SPAN&gt;"Sheet2"&lt;/SPAN&gt;)&lt;/PRE&gt;&lt;P&gt;Another method is to use the Path function of the document your running the rule on to give the directory The file is stored in.&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Open&lt;/SPAN&gt;(ThisDoc.Path &amp;amp; "&lt;SPAN&gt;\dwg-param.xlsx"&lt;/SPAN&gt;, &lt;SPAN&gt;"Sheet2"&lt;/SPAN&gt;)&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 10 Jan 2023 15:24:59 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/import-replace-embedded-xlsx-file-through-form-built-with-ilogic/m-p/11669313#M147600</guid>
      <dc:creator>A.Acheson</dc:creator>
      <dc:date>2023-01-10T15:24:59Z</dc:date>
    </item>
    <item>
      <title>Re: Import/replace embedded .xlsx file through form built with iLogic</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/import-replace-embedded-xlsx-file-through-form-built-with-ilogic/m-p/11681989#M147768</link>
      <description>&lt;P&gt;Hi, sorry for the late response - i've been caught up in learning iLogic, as i find it very fun to write.&amp;nbsp;&lt;/P&gt;&lt;P&gt;The frustration i get from a non functioning code just gives me more drive to solve it, so i end up hyperfocusing on it and forget everything else around me, so i just now remembered that i made this post.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I ended up going away from the embedding/replace embedded file method and decided using goexcel. I've created a standard sheet layout which is locked, so the people using my tool wont be able to mess up the cells, then i set iLogic to read from the driving sheet cells. which reference a userfriendly sheet within the same excel file.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;solved my issue by using the following code:&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;'Declare Iventor File Dialog&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oFileDlg&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Inventor&lt;/SPAN&gt;.&lt;SPAN&gt;FileDialog&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oDocFile&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Document&lt;/SPAN&gt;, &lt;SPAN&gt;oDocFileName&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt;
&lt;SPAN&gt;'Run File Selection Code&lt;/SPAN&gt;
&lt;SPAN&gt;InventorVb&lt;/SPAN&gt;.&lt;SPAN&gt;Application&lt;/SPAN&gt;.&lt;SPAN&gt;CreateFileDialog&lt;/SPAN&gt;(&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;)

&lt;SPAN&gt;'Allow Selection Of Excel Files&lt;/SPAN&gt;
&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;Filter&lt;/SPAN&gt; = &lt;SPAN&gt;"Excel Spec Sheet (*.xls;*.xlsx;*xlsm)|*.xls;*.xlsx;*xlsm"&lt;/SPAN&gt;

&lt;SPAN&gt;'Get File Path, setting the initial path to the same folder that the model is saved In.&lt;/SPAN&gt;
&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;InitialDirectory&lt;/SPAN&gt; = &lt;SPAN&gt;ThisDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Path&lt;/SPAN&gt;
&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;CancelError&lt;/SPAN&gt; = &lt;SPAN&gt;True&lt;/SPAN&gt;
&lt;SPAN&gt;On&lt;/SPAN&gt; &lt;SPAN&gt;Error&lt;/SPAN&gt; &lt;SPAN&gt;Resume&lt;/SPAN&gt; &lt;SPAN&gt;Next&lt;/SPAN&gt;

&lt;SPAN&gt;'Show Open File Dialog Window.&lt;/SPAN&gt;
&lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;ShowOpen&lt;/SPAN&gt;()

&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;FileName&lt;/SPAN&gt; = &lt;SPAN&gt;""&lt;/SPAN&gt; 
	&lt;SPAN&gt;MessageBox&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;"No File Selected"&lt;/SPAN&gt;, &lt;SPAN&gt;"Error"&lt;/SPAN&gt;)

&lt;SPAN&gt;GoTo&lt;/SPAN&gt; &lt;SPAN&gt;LAUNCH_FORM&lt;/SPAN&gt;
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;


&lt;SPAN&gt;'declares selected file name&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;xSpec&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; = &lt;SPAN&gt;oFileDlg&lt;/SPAN&gt;.&lt;SPAN&gt;FileName&lt;/SPAN&gt;
&lt;SPAN&gt;'Set Filename parameter to the path.&lt;/SPAN&gt;
	&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"Filename"&lt;/SPAN&gt;) = &lt;SPAN&gt;xSpec&lt;/SPAN&gt;
	&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"Veneer:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"VeneerDepth"&lt;/SPAN&gt;) = &lt;SPAN&gt;VeneerDepthBuild&lt;/SPAN&gt;
	&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"Veneer:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"VeneerWidth"&lt;/SPAN&gt;) = &lt;SPAN&gt;VeneerWidthBuild&lt;/SPAN&gt;
	&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"Veneer:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"VeneerHeight"&lt;/SPAN&gt;) = &lt;SPAN&gt;VeneerHeightBuild&lt;/SPAN&gt;
	&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossH"&lt;/SPAN&gt;) = &lt;SPAN&gt;CrossHeightBuild&lt;/SPAN&gt;
	&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossD"&lt;/SPAN&gt;) = &lt;SPAN&gt;CrossDepthBuild&lt;/SPAN&gt;
	&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossW"&lt;/SPAN&gt;) = &lt;SPAN&gt;CrossWidthBuild&lt;/SPAN&gt;
	&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:2"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossH"&lt;/SPAN&gt;) = &lt;SPAN&gt;CrossHeightBuild&lt;/SPAN&gt;
	&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:2"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossD"&lt;/SPAN&gt;) = &lt;SPAN&gt;CrossDepthBuild&lt;/SPAN&gt;
	&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:2"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossW"&lt;/SPAN&gt;) = &lt;SPAN&gt;CrossWidthBuild&lt;/SPAN&gt;
	&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossOffBot"&lt;/SPAN&gt;) = &lt;SPAN&gt;CrossOffBuild&lt;/SPAN&gt;
	&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CtopOffset"&lt;/SPAN&gt;) = &lt;SPAN&gt;CtopOffsetBuild&lt;/SPAN&gt;
	&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;Open&lt;/SPAN&gt;(&lt;SPAN&gt;xSpec&lt;/SPAN&gt;, &lt;SPAN&gt;"Driver"&lt;/SPAN&gt;)
&lt;SPAN&gt;VeneerHeightBuild&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;xSpec&lt;/SPAN&gt;, &lt;SPAN&gt;"Driver"&lt;/SPAN&gt;, &lt;SPAN&gt;"B7"&lt;/SPAN&gt;)
&lt;SPAN&gt;VeneerDepthBuild&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;xSpec&lt;/SPAN&gt;, &lt;SPAN&gt;"Driver"&lt;/SPAN&gt;, &lt;SPAN&gt;"C7"&lt;/SPAN&gt;)
&lt;SPAN&gt;VeneerWidthBuild&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;xSpec&lt;/SPAN&gt;, &lt;SPAN&gt;"Driver"&lt;/SPAN&gt;, &lt;SPAN&gt;"D7"&lt;/SPAN&gt;)
&lt;SPAN&gt;CrossHeightBuild&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;xSpec&lt;/SPAN&gt;, &lt;SPAN&gt;"Driver"&lt;/SPAN&gt;, &lt;SPAN&gt;"B6"&lt;/SPAN&gt;)
&lt;SPAN&gt;CrossDepthBuild&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;xSpec&lt;/SPAN&gt;, &lt;SPAN&gt;"Driver"&lt;/SPAN&gt;, &lt;SPAN&gt;"C6"&lt;/SPAN&gt;)
&lt;SPAN&gt;CrossWidthBuild&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;xSpec&lt;/SPAN&gt;, &lt;SPAN&gt;"Driver"&lt;/SPAN&gt;, &lt;SPAN&gt;"H12"&lt;/SPAN&gt;)
&lt;SPAN&gt;CrossOffBuild&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;xSpec&lt;/SPAN&gt;, &lt;SPAN&gt;"Driver"&lt;/SPAN&gt;, &lt;SPAN&gt;"H7"&lt;/SPAN&gt;)
&lt;SPAN&gt;CtopOffsetBuild&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;xSpec&lt;/SPAN&gt;, &lt;SPAN&gt;"Driver"&lt;/SPAN&gt;, &lt;SPAN&gt;"H8"&lt;/SPAN&gt;)
&lt;SPAN&gt;FirstVeneerOffset&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;xSpec&lt;/SPAN&gt;, &lt;SPAN&gt;"Driver"&lt;/SPAN&gt;, &lt;SPAN&gt;"-H6"&lt;/SPAN&gt;)
&lt;SPAN&gt;ModuleDim&lt;/SPAN&gt; = &lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;CellValue&lt;/SPAN&gt;(&lt;SPAN&gt;xSpec&lt;/SPAN&gt;, &lt;SPAN&gt;"Driver"&lt;/SPAN&gt;, &lt;SPAN&gt;"D6"&lt;/SPAN&gt;)
	&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;close&lt;/SPAN&gt;

&lt;SPAN&gt;'ask if user wants to update dialog&lt;/SPAN&gt;
&lt;SPAN&gt;question&lt;/SPAN&gt; = &lt;SPAN&gt;MessageBox&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;"Update model To spec sheet?"&lt;/SPAN&gt;, &lt;SPAN&gt;"xxx Gen v.3"&lt;/SPAN&gt;, &lt;SPAN&gt;MessageBoxButtons&lt;/SPAN&gt;.&lt;SPAN&gt;YesNo&lt;/SPAN&gt;, &lt;SPAN&gt;MessageBoxIcon&lt;/SPAN&gt;.&lt;SPAN&gt;Question&lt;/SPAN&gt;, &lt;SPAN&gt;MessageBoxDefaultButton&lt;/SPAN&gt;.&lt;SPAN&gt;Button1&lt;/SPAN&gt;)
	&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;question&lt;/SPAN&gt; = &lt;SPAN&gt;vbYes&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;.&lt;SPAN&gt;UpdateAfterChange&lt;/SPAN&gt; = &lt;SPAN&gt;True&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;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"Filename"&lt;/SPAN&gt;) = &lt;SPAN&gt;xSpec&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"Veneer:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"VeneerDepth"&lt;/SPAN&gt;) = &lt;SPAN&gt;VeneerDepthBuild&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"Veneer:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"VeneerWidth"&lt;/SPAN&gt;) = &lt;SPAN&gt;VeneerWidthBuild&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"Veneer:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"VeneerHeight"&lt;/SPAN&gt;) = &lt;SPAN&gt;VeneerHeightBuild&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossH"&lt;/SPAN&gt;) = &lt;SPAN&gt;CrossHeightBuild&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossD"&lt;/SPAN&gt;) = &lt;SPAN&gt;CrossDepthBuild&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossW"&lt;/SPAN&gt;) = &lt;SPAN&gt;CrossWidthBuild&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:2"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossH"&lt;/SPAN&gt;) = &lt;SPAN&gt;CrossHeightBuild&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:2"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossD"&lt;/SPAN&gt;) = &lt;SPAN&gt;CrossDepthBuild&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:2"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossW"&lt;/SPAN&gt;) = &lt;SPAN&gt;CrossWidthBuild&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossOffBot"&lt;/SPAN&gt;) = -&lt;SPAN&gt;CrossOffBuild&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CtopOffset"&lt;/SPAN&gt;) = &lt;SPAN&gt;CtopOffsetBuild&lt;/SPAN&gt;

	&lt;SPAN&gt;Else&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;question&lt;/SPAN&gt; = &lt;SPAN&gt;vbNo&lt;/SPAN&gt; &lt;SPAN&gt;Then&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;.&lt;SPAN&gt;UpdateAfterChange&lt;/SPAN&gt; = &lt;SPAN&gt;False&lt;/SPAN&gt;
		&lt;SPAN&gt;iLogicVb&lt;/SPAN&gt;.&lt;SPAN&gt;UpdateWhenDone&lt;/SPAN&gt; = &lt;SPAN&gt;False&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"Veneer:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"VeneerDepth"&lt;/SPAN&gt;) = &lt;SPAN&gt;DefaultVD&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"Veneer:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"VeneerWidth"&lt;/SPAN&gt;) = &lt;SPAN&gt;DefaultVW&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"Veneer:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"VeneerHeight"&lt;/SPAN&gt;) = &lt;SPAN&gt;DefaultVH&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossH"&lt;/SPAN&gt;) = &lt;SPAN&gt;DefaultCH&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossD"&lt;/SPAN&gt;) = &lt;SPAN&gt;DefaultCD&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:1"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossW"&lt;/SPAN&gt;) = &lt;SPAN&gt;DefaultCW&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:2"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossH"&lt;/SPAN&gt;) = &lt;SPAN&gt;DefaultCH&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:2"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossD"&lt;/SPAN&gt;) = &lt;SPAN&gt;DefaultCD&lt;/SPAN&gt;
		&lt;SPAN&gt;Parameter&lt;/SPAN&gt;(&lt;SPAN&gt;"CrossBar:2"&lt;/SPAN&gt;, &lt;SPAN&gt;"CrossW"&lt;/SPAN&gt;) = &lt;SPAN&gt;DefaultCW&lt;/SPAN&gt;
	&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;
	
&lt;SPAN&gt;LAUNCH_FORM&lt;/SPAN&gt;:
&lt;SPAN&gt;iLogicForm&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;"xxx Product Generator"&lt;/SPAN&gt;)

&lt;/PRE&gt;</description>
      <pubDate>Mon, 16 Jan 2023 10:03:01 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/import-replace-embedded-xlsx-file-through-form-built-with-ilogic/m-p/11681989#M147768</guid>
      <dc:creator>op_thorsager</dc:creator>
      <dc:date>2023-01-16T10:03:01Z</dc:date>
    </item>
  </channel>
</rss>

