Excel 2010 - Splitting files in folder

[newuser123]

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​

 

[alow]

There is a free utility described and linked to here that looks like it will do what you need.

 

[newuser123]

Thanks but that utility only does a single file at a time with the user having to input each one.

I have managed to write my own VBA subroutine for this.