View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jo77 jo77 is offline
external usenet poster
 
Posts: 6
Default Split a text file with more than 65536 lines over many worksheets

Hi everyone,
I would like to process a text file with more than 65536 lines. Is
there any possiblity to do that with Excel ?
Either to do it in many iterations (like import lines 1 to 65536, then
65537 to 131072, and so on) or to import it once and split lines 1 to
65536 on sheet 1, lines 65537 to 131072 on sheet 2 etc...

Thanks for any feedback & have a great weekend!

Joel