<?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: Replace Excel using ilogic code in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/replace-excel-using-ilogic-code/m-p/11229009#M139197</link>
    <description>&lt;P&gt;Can you please provide the ilogic code your are using to generate the excel message dialog? Are you overwriting an excel file?&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Sat, 11 Jun 2022 17:36:36 GMT</pubDate>
    <dc:creator>A.Acheson</dc:creator>
    <dc:date>2022-06-11T17:36:36Z</dc:date>
    <item>
      <title>Replace Excel using ilogic code</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/replace-excel-using-ilogic-code/m-p/11228535#M139187</link>
      <description>&lt;P&gt;How can i replace Excel file with "yes" as shown below image using ilogc code.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="karram_0-1654930053795.png" style="width: 600px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1078676i59374F8F11579478/image-size/medium?v=v2&amp;amp;px=400" role="button" title="karram_0-1654930053795.png" alt="karram_0-1654930053795.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 11 Jun 2022 06:48:32 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/replace-excel-using-ilogic-code/m-p/11228535#M139187</guid>
      <dc:creator>karram</dc:creator>
      <dc:date>2022-06-11T06:48:32Z</dc:date>
    </item>
    <item>
      <title>Re: Replace Excel using ilogic code</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/replace-excel-using-ilogic-code/m-p/11229009#M139197</link>
      <description>&lt;P&gt;Can you please provide the ilogic code your are using to generate the excel message dialog? Are you overwriting an excel file?&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 11 Jun 2022 17:36:36 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/replace-excel-using-ilogic-code/m-p/11229009#M139197</guid>
      <dc:creator>A.Acheson</dc:creator>
      <dc:date>2022-06-11T17:36:36Z</dc:date>
    </item>
    <item>
      <title>Re: Replace Excel using ilogic code</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/replace-excel-using-ilogic-code/m-p/11229102#M139200</link>
      <description>&lt;P&gt;Herewith attached code below.&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;'Save Excel files as current folder patch&lt;/SPAN&gt;
&lt;SPAN&gt;oPath&lt;/SPAN&gt; = &lt;SPAN&gt;ThisDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Path&lt;/SPAN&gt;
&lt;SPAN&gt;oFolder&lt;/SPAN&gt; = &lt;SPAN&gt;oPath&lt;/SPAN&gt;
&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;Not&lt;/SPAN&gt; &lt;SPAN&gt;System&lt;/SPAN&gt;.&lt;SPAN&gt;IO&lt;/SPAN&gt;.&lt;SPAN&gt;Directory&lt;/SPAN&gt;.&lt;SPAN&gt;Exists&lt;/SPAN&gt;(&lt;SPAN&gt;oFolder&lt;/SPAN&gt;) &lt;SPAN&gt;Then&lt;/SPAN&gt;
    &lt;SPAN&gt;System&lt;/SPAN&gt;.&lt;SPAN&gt;IO&lt;/SPAN&gt;.&lt;SPAN&gt;Directory&lt;/SPAN&gt;.&lt;SPAN&gt;CreateDirectory&lt;/SPAN&gt;(&lt;SPAN&gt;oFolder&lt;/SPAN&gt;)
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;

&lt;SPAN&gt;myXLS_File&lt;/SPAN&gt; = &lt;SPAN&gt;oFolder&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;"\"&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;xlDocID&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;".xls"&lt;/SPAN&gt;
&lt;SPAN&gt;xlWB&lt;/SPAN&gt;.&lt;SPAN&gt;SaveAs&lt;/SPAN&gt;(&lt;SPAN&gt;myXLS_File&lt;/SPAN&gt;) = &lt;SPAN&gt;True&lt;/SPAN&gt;
&lt;SPAN&gt;GoExcel&lt;/SPAN&gt;.&lt;SPAN&gt;DisplayAlerts&lt;/SPAN&gt; = &lt;SPAN&gt;True&lt;/SPAN&gt;
&lt;SPAN&gt;myXLS_File&lt;/SPAN&gt;.&lt;SPAN&gt;close&lt;/SPAN&gt;&lt;/PRE&gt;</description>
      <pubDate>Sat, 11 Jun 2022 19:23:05 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/replace-excel-using-ilogic-code/m-p/11229102#M139200</guid>
      <dc:creator>karram</dc:creator>
      <dc:date>2022-06-11T19:23:05Z</dc:date>
    </item>
    <item>
      <title>Re: Replace Excel using ilogic code</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/replace-excel-using-ilogic-code/m-p/11229141#M139202</link>
      <description>&lt;P&gt;Can you post more of the code your using and explain the design intent of what your looking to achieve. Are you exporting a BOM or saving a new excel workbook?&amp;nbsp; Go Excel has no Save as method so you might need to switch to Excel Application to to do the work.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 11 Jun 2022 20:16:45 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/replace-excel-using-ilogic-code/m-p/11229141#M139202</guid>
      <dc:creator>A.Acheson</dc:creator>
      <dc:date>2022-06-11T20:16:45Z</dc:date>
    </item>
    <item>
      <title>Re: Replace Excel using ilogic code</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/replace-excel-using-ilogic-code/m-p/11229163#M139204</link>
      <description>&lt;P&gt;Yes! i am export BOM with specific folder. But while Exporting again and again with same file name using automatically replace with YES using ilogic code&lt;/P&gt;</description>
      <pubDate>Sat, 11 Jun 2022 20:48:19 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/replace-excel-using-ilogic-code/m-p/11229163#M139204</guid>
      <dc:creator>karram</dc:creator>
      <dc:date>2022-06-11T20:48:19Z</dc:date>
    </item>
    <item>
      <title>Re: Replace Excel using ilogic code</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/replace-excel-using-ilogic-code/m-p/11229191#M139206</link>
      <description>&lt;P&gt;You can first check if the file exist then just delete the file before exporting the New BOM. This will eliminate the need to overwrite the file and prevent the dialog.&amp;nbsp; Although in my testing the standard BOM export will automatically overwrite the file without the warning dialog. I suspect that the larger rule you are using has other issues with the workflow. Please share the entire rule if this is still an issue.&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;'Check if file exists, if it does then delete &lt;/SPAN&gt;
&lt;SPAN&gt;If&lt;/SPAN&gt; &lt;SPAN&gt;System&lt;/SPAN&gt;.&lt;SPAN&gt;IO&lt;/SPAN&gt;.&lt;SPAN&gt;File&lt;/SPAN&gt;.&lt;SPAN&gt;Exists&lt;/SPAN&gt;(&lt;SPAN&gt;myXLS_File&lt;/SPAN&gt;) &lt;SPAN&gt;Then&lt;/SPAN&gt;
	&lt;SPAN&gt;System&lt;/SPAN&gt;.&lt;SPAN&gt;IO&lt;/SPAN&gt;.&lt;SPAN&gt;File&lt;/SPAN&gt;.&lt;SPAN&gt;Delete&lt;/SPAN&gt;(&lt;SPAN&gt;myXLS_File&lt;/SPAN&gt;)
&lt;SPAN&gt;End&lt;/SPAN&gt; &lt;SPAN&gt;If&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 11 Jun 2022 21:36:04 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/replace-excel-using-ilogic-code/m-p/11229191#M139206</guid>
      <dc:creator>A.Acheson</dc:creator>
      <dc:date>2022-06-11T21:36:04Z</dc:date>
    </item>
  </channel>
</rss>

