A newer HTML application (HTA) has just been created which accomplishes the same thing but in a more customizable manner. Click here to read the post.
A few days ago, someone asked me to help them convert a large number of XLS files to CSV. Since, while working for Bristol-Myers Squibb, I became very familiar with writing macros and JScripts to work with Excel, I decided to write a JScript to accomplish the task. Basically, all you have to do is put the script inside of the same folder as all of the Excel files and double-click it to run it. The script uses Excel to open all of the files and convert each worksheet of each XLS file to a CSV. The naming convention for the CSV files is as follows:
Here is the script:
Excel – XLS To CSV Converter
If you examine the script, you will notice that it uses jPaq for user interaction. All of the code, except for the jPaq because it is the minifieid version, is pretty well documented. You may do whatever you want to the script. All I ask is that, if you re-use the code, you give credit where it is due. 🙂