Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening text files that have more rows than 65536 | Excel Worksheet Functions | |||
how do I convert an excel file to a flat text file | Excel Discussion (Misc queries) | |||
Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
I have a Comma delimited text file how do I import in to excel an. | Excel Discussion (Misc queries) |