Opening a text file partway through

Tim Grollman

Board Regular
Joined
Feb 24, 2002
Messages
129
I have a text file which is 200,000 lines long. I am trying to import it to Excel, via a macro, in four blocks. It doesn't seem to be happy with a StartRow above line 32000 however. Is there a way round this, does anybody know? Thanks.
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,621
Members
410,804
Latest member
bluepinky
Top