View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
[email protected] par_60056@hotmail.com is offline
external usenet poster
 
Posts: 42
Default VBA Runtime error 14: Out of string space... help!

On Jul 24, 11:34 am, smurray444
wrote:
Thanks for your replies again.

I have tried changing the maximum row value to a range of numbers (as low as
20!), but the same result occurs.

With regard to the latest point, the text file is fomatted as follows:

-67.45832 82.87501 0.2068079
-67.37498 82.87501 0.2068079
-67.29166 82.87501 0.2068079
-67.20832 82.87501 0.2068079
-67.12498 82.87501 0.2068079
-67.04166 82.87501 0.2068079
-66.95832 82.87501 0.2068079
-66.87498 82.87501 0.2068079
-66.79166 82.87501 0.2068079 ...etc etc...

However, when displayed in Notepad, the rectangle (carriage return?) symbol
separates each row (i.e. it is displayed as one long string and not in
columns as shown above... although the above is the result of a direct copy
and paste!). So maybe this is causing a problem? If so, is there a way of
getting round this? It would take ages to go though the text file
reformatting it and removing the symbols for example.

Any ideas would be very much appreciated.

The file has line feeds without carriage returns so to the line input
function it is 1 LONG string.

You can try loading it with WORDPAD which should read it fine and look
right and then try saving it and see if it looks right in NOTEPAD. I
know that is a LONG processed with a file that huge.

That is normally from a file produced on a problem of a file that came
from a UNIX system. There are utilities on the new to convert UNIX to
DOS files. This simply adds the CR after the LF.

Peter Richardson