While working with Data conversions or ETL, files in CSV formats are easy to process on various systems and platforms. The VB Script given here can quickly convert your XLS or XLSX files into CSV. How to use this script? Command line mode: Execute this VB Script with name of each excel file as an argument.      Example:

• Convert_To_CSV.vbs <file1.xls> <file2.xls> <file3.xls>?..

GUI Mode: Select all your XLS files, drag them and drop them over vbs file icon.You can download this listing as part of the PowerCenter : Useful Script files bundle.