Can I change an Excel file to CSV (Comma Delimited) in a batch
Posted on 2014-02-13
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
Daily Red Wagons
Daily Red Trains
Daily Blue Wagons
Daily Blue Trains