Dividing a large excel file to multiple files

[etrader]

Is there a way to save a large excel file to multiple (e.g. text) files. Dividing, e.g every 1500 rows to a single text file.

[JBeaucaire]

1) You can do it manually, copy 1500 rows at a time to another sheet, then save the sheet as TXT.

2) You can use a macro to do it for you.

A macro would need to know:
a) Does the data have a row of titles in row1 that has to be included with every set of data?

b) If there is a row of titles to include, does that mean you want the row of titles and 1500 rows of data, or 1499?

c) What is the path you want the files saved to?

d) What is the naming system you want used for the new files that will be created?