Hi all,
Just wonder anyone could advise of any code to split a file into two
before importing the files into excel....this is because the file data
has exceeded the limitation of excel(too many lines). I am looking for a
way to split a file into two(one with 30000 line of data) while the
other with the rest of the lines of data before importing them to excel.
Thanks in advance.