input file with more than 250000 lines
 

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

input file with more than 250000 lines
 

This link leads to code from Bernie Deitrick

http://redirx.com/?334z

--
Kind regards,

Niek Otten

"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
|

input file with more than 250000 lines
 

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
|