Excel 2010 - Splitting files in folder
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
Re: Excel 2010 - Splitting files in folder
Quote:
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?