I wrote a script that parses long text files into files of 65k lines more as
an exercise than anything else. It's attached. Rename the extension to VBS
and then you can double-click it to run it.

--
Jim

"green1111" wrote
in message ...
|
| I need to work with input file with more than 250,000 lines but Excel
| allow me to take in data with less than 65,000 lines only. How to
| sslice my data in 5 worksheet so that I can work with my data ? Is
| there any work around ? Thanks....
|
|
| --
| green1111
| ------------------------------------------------------------------------
| green1111's Profile:
http://www.excelforum.com/member.php...o&userid=33863
| View this thread: http://www.excelforum.com/showthread...hreadid=536414
|