Convert XLS Files to CSV From Command Line

This is how you can convert an XLS file to a CSV file using the Windows command line. You'll need to create a VBScript to do this.

Split Excel File Into Multiple Excel Files, Based on Number of Rows

Let's assume you have an Excel Spreadsheet with 30000 rows in it and you need to split it into individual Spreadsheets with 3000 rows each. You can do this by creating a VBA Script and execute it from the Excel VBA Editor.