Macro that will seperate a workbook into smaller ones

Hello people,

I have tons of workbooks that need to be imported into another program.
The problem is that the workbooks must be 99 lines each.So what i'm
looking for is a macro that will seperate the whole workbook wich might be 500 lines or so,into other workbooks with 99 lines each.

If you don't understand something or have some questions please ask me!

Thanks for reading my question

Hi
Pl post a sample workbook
ravi

Hey there,thanks for looking at my question.
Here is a sample workbook

620 ok.xls

Nothing changes at cells,it just might have more or less lines

Not many replies i see...either it's too difficult or too easy to bother with

Anyway,i have no problem if it can be splitted into spreadsheets either.Same too me...it's just too tiring to do it manualy


If anyone can help...i'd really appreciate it