View Single Post
  #1   Report Post  
AriBari
 
Posts: n/a
Default Import only certain rows of a huge text file


Hello,

I try to open a 27MB text file (~ 495670 rows) and import rows 495662 -
496665 to an Excel sheet. Too many rows to handle with the Wizard.

I would like to have a VBA sub to open file, fetch given rows, copy
those to an Excel sheet and close text file. I have to do this for
300-400 text files that are numbered in ascending order but not
necessarily continuously, that is 01,02,03,05,07 etc.

Thanks for the help.

Ari Bari


--
AriBari
------------------------------------------------------------------------
AriBari's Profile: http://www.excelforum.com/member.php...o&userid=25043
View this thread: http://www.excelforum.com/showthread...hreadid=385663