Divide worsheet and save as separate files
 

Hi

I have a worksheet which I need to split into smaller files and save one
by one in a separate folder.

I need a small routine to take off the first 999 rows (file name 1 -
999) and save it in a separate folder (C:\files).

Then it would take the next 999 (file name 1000 - 1999) and save them as
a separate file in the same folder and so on until the end of the file
is reached. This would give me a folder with my main file split into
smaller files of 999 each.

Is it possible to automate this by VBA in this way?

Hope someone can help.


Best Wishes

Drno