splitting a file into two before importing it to excel

  • Thread starter Thread starter Secret Character
  • Start date Start date
S

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.
 
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.
Click to expand...

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
 
Back
Top