splitting a file into two before importing it to excel

[Secret Character]

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.

 

[TG]

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