I read this question: Can I split a spreadsheet into multiple files based on a column in Excel 2007?
I have a question regarding the "Save in same format as original workbook" that I hope you can help me with.
I'm using the macro with a CSV file but I want to have the final files like XLS.
How can the macro be changed to save in this format (different than original one)?