<div>
Which version of Excel?<br />
<br />
If using 2007 or later the original file will be an xlsm (macro enabled). If you save as an xls it will save without the macros.<br />
<br />
Thanks<br />
Rob H
</div>


Which version of Excel?

If using 2007 or later the original file will be an xlsm (macro enabled). If you save as an xls it will save without the macros.

Thanks
Rob H

<div>
I'm using Excel 2010.<br />
The code in the VB script that saves the new file is<br />
<br />
&nbsp;ThisWorkbook.SaveAs ThisWorkbook.Path &amp;&nbsp;&quot;\Report_&quot; &amp;&nbsp;getDateTimeStamp() &amp;&nbsp;&quot;.xls&quot;, XlFileFormat.xlExcel8<br />
<br />
What needs to change above to save the workbook without macros or code carried over?
</div>


I'm using Excel 2010.
The code in the VB script that saves the new file is

 ThisWorkbook.SaveAs ThisWorkbook.Path & "\Report_" & getDateTimeStamp() & ".xls", XlFileFormat.xlExcel8

What needs to change above to save the workbook without macros or code carried over?

<div>
Hi kris,<br />
<br />
You should try copying the workbook and then saving the copied version which doesn't include the VB code. Please refer to the last post by &quot;johnske&quot; here:<br />
<br />
<a href="http://www.vbaexpress.com/forum/showthread.php?t=17337" rel="ugc">http://www.vbaexpress.com/forum/showthread.php?t=17337</a><br />
<br />
Regards,<br />
urzica
</div>


Hi kris,

You should try copying the workbook and then saving the copied version which doesn't include the VB code. Please refer to the last post by "johnske" here:

http://www.vbaexpress.com/forum/showthread.php?t=17337 [http://www.vbaexpress.com/forum/showthread.php?t=17337]

Regards,
urzica

<div>
<div class="content wysiwyg-content">
My excel macro is executed from command line using Workbook_Open()<br />
<br />
At the end of the macro, the template file from where the code is running, saves a output file with date time stamp.<br />
But the output file has the code as well, and when I open the output file, Workbook_Open() executes again with error.<br />
How can I save the output file with out copying over the VB code/macro?
</div>
</div>


My excel macro is executed from command line using Workbook_Open()

At the end of the macro, the template file from where the code is running, saves a output file with date time stamp.
But the output file has the code as well, and when I open the output file, Workbook_Open() executes again with error.
How can I save the output file with out copying over the VB code/macro?

Remove VB code from saved Excel file

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.