software

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: www.excelforum.com/member.php...oamp;userid=33863
View this thread: www.excelforum.com/showthread...hreadid=536414This link leads to code from Bernie Deitrick

redirx.com/?334z

--
Kind regards,

Niek Otten

quot;green1111quot; gt; 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: www.excelforum.com/member.php...oamp;userid=33863
| View this thread: www.excelforum.com/showthread...hreadid=536414
|
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

quot;green1111quot; gt; 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:
www.excelforum.com/member.php...oamp;userid=33863
| View this thread: www.excelforum.com/showthread...hreadid=536414
|