LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
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.

Many thanks
Steve


Under the heading of proofread before hitting send that should read:

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

Peter Richardson

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Runtime 28 - Out of stack space Oggy Excel Programming 7 May 9th 07 01:31 PM
Number of space in a string [email protected] Excel Discussion (Misc queries) 5 November 8th 06 11:15 PM
Can I find a string with or without a space after the last charact emil Excel Programming 5 June 11th 06 08:50 AM
how to remove a space after a string? elaine Excel Programming 3 June 9th 06 03:00 PM
NEED HELP-----Removing a space at the end of a string of character FRS Excel Discussion (Misc queries) 7 April 13th 06 03:57 AM


All times are GMT +1. The time now is 07:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"