+ Reply to Thread
Results 1 to 4 of 4

Error 14. Out of string space.

  1. #1
    Forum Contributor
    Join Date
    07-16-2007
    MS-Off Ver
    Excel 2003 and Excel 2016
    Posts
    178

    Error 14. Out of string space.

    I found some code written by Chip Pearson that allows importing a large text file into Excel. I tried it on a file that was nearly 400mb and got an Error14 when I tried to convert vbLf to vbCr in one of his functions (which tries to load the entire text file into one string). Does anyone know a work around?

    Thanks.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Error 14. Out of string space.

    That's a very big string. Maybe try with 64-bit Excel and lots of memory.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Error 14. Out of string space.

    .... or read the file one line at a time (probably an order of magnitude slower, but without the runtime error) using code like one of the following from the attached workbook:
    Please Login or Register  to view this content.
    Lewis
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    07-16-2007
    MS-Off Ver
    Excel 2003 and Excel 2016
    Posts
    178

    Re: Error 14. Out of string space.

    Thank you very much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. replace space in string with non-space
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2012, 02:59 AM
  2. space in string
    By yellowpower in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2010, 06:16 AM
  3. Split a string where the space is???
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2008, 07:25 AM
  4. Out of string space...
    By smurray444 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2007, 05:47 PM
  5. Adding a space to a string
    By lennymos123 in forum Excel General
    Replies: 2
    Last Post: 05-10-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1