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.

On Dec 21, 1:23 pm, Secret Character wrote:
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.

Maybe, what kind of file? Is it a text-file??

You could try to use ReadFromFile, (search in the VBA-Help)
and when you reach line 30000 change to a new input (sheet)..

/Tommy, DK