Splitting a 24k Rows Worksheet into Smaller Chunks

Hi all, I have a spreadsheet with around 24 Thousand rows in it and wonder if there is any way to programatically / batch process to make it into 240 workbooks each named as the numbers they are:

1-100.xls
101-200.xls
201-300.xls

etc etc.....

This would save me manually doing it!

Thanks in advance, Steve @ Woods Online