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.