Excel 2010 - Splitting files in folder

[duggie]

I have several txt files in a folder, say FileA.txt, FileB.txt, etc.

They exceed 1 million rows so I would like to split them, create FileA_1.txt, FileA_2.txt, etc. FileB_1.txt, FileB_2.txt, etc. and store them newly created files in a different location to the original files.

Does anybody have any code to do this?

Thanks

[westconn1]

Does anybody have any code to do this?

i have code that can do like this, but it will not work to end of line, just fixed file size, i am sure it could be modified
how big in size are the text files?
how big do you want the output files?
you want the files split at a given number of lines or file size?