View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Navin Navin is offline
external usenet poster
 
Posts: 5
Default export a text file which more than 65536 rows into excel

guys i wanna export a text file which more than 65536 rows
into excel
excel has limation of transferring data to excel to 65536
now how do i handle rows more than 65536 if wanna export it to excel
i need to create extra spreadheets and export into it.
so do i go abt it...
i wanna do it way the fastest.
can you show me macro where by i can export all my data into excel and
create new sheets on the fly.