I do exactly this via macro all the time. The Macro Recorder can give you the code you need. I usually open a new workbook and give it a name like "DeleteMe.xls", then copy my data to it, save as my CSV, then close it.
Attach the macro to a button, and the user never has to know what is going on behind the scenes!