On May 13, 10:38*am, wrote:
On May 12, 8:38*pm, wrote:

In the mean time for an urgent work around I found in MS Knowledge
Base

http://support.microsoft.com/default...b;en-us;120596

that contains a macro for importing large row text files by splitting
the input into multiple worksheets. *I have it tested and have it
running, and it does the urgent CSV file job I needed, and although
sucessful it does terminate with a debug error. While I've created
macros before, the script in this one is beyond my current skills, so
for now I've added a reply to the MS page with a feedback comment.

--
Nick

A further test, I've found the debug error only arises if the input
files is *exactly* 65536 or exact multiples of 65536 lines long.
Works fine with other file lengths.


--
Nick