<div>
No way to do this in a pure batch (BAT) script solution. &nbsp;Would a vbscript (VBS) script solution be acceptable?<br />
<br />
~bp
</div>


No way to do this in a pure batch (BAT) script solution.  Would a vbscript (VBS) script solution be acceptable?

~bp

<div>
Yes, a VBS script would be acceptable.
</div>


<div>
PowerShell is another option. The code is nearly the same as in VBS.
</div>


PowerShell is another option. The code is nearly the same as in VBS.

<div>
<div class="content wysiwyg-content">
I have daily excel files that I would like to convert to CSV (Comma Delimited) with a batch. &nbsp;When I manually convert the files I get Microsoft advising me some features are not compatible and do I want to keep the workbook in this format, so I click Yes and it converts to CSV. &nbsp;Then when I try to close the book, it asks do I want to save changes made to CSV file. &nbsp;I click no and it closes and I have my CSV file ready to go. &nbsp;<br />
<br />
I would like to create a batch to transfer the files to CSV (Comma Delimited) and close the files. &nbsp;<br />
<br />
Also, if possible I would like to add today's date on each file. Example 2014-02-13<br />
<br />
File Names:<br />
Daily Red Wagons<br />
Daily Red Trains<br />
Daily Blue Wagons<br />
Daily Blue Trains<br />
<br />
Thanks,
</div>
</div>


I have daily excel files that I would like to convert to CSV (Comma Delimited) with a batch.  When I manually convert the files I get Microsoft advising me some features are not compatible and do I want to keep the workbook in this format, so I click Yes and it converts to CSV.  Then when I try to close the book, it asks do I want to save changes made to CSV file.  I click no and it closes and I have my CSV file ready to go.  

I would like to create a batch to transfer the files to CSV (Comma Delimited) and close the files.  

Also, if possible I would like to add today's date on each file. Example 2014-02-13

File Names:
Daily Red Wagons
Daily Red Trains
Daily Blue Wagons
Daily Blue Trains

Thanks,

Can I change an Excel file to CSV (Comma Delimited) in a batch

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

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.