Out of string space...

**smurray444** · 07-24-2007, 07:06 AM

Dear all,

I'm using the VBA code found at the following URL to import a large text file into Excel 2007 across several worksheets:

http://support.microsoft.com/kb/120596/EN-US/

The only change that I've made is to update the maximum row number from 65536 to 1048576 to account for this version of Excel.

However, when I run the code I receive the following error:

Run-time error 14: Out of string space.

Does anyone have any ideas as to what this refers to and how I might go about solving it?

Thanks for your help,
Steve

**JR@SGC** · 07-24-2007, 08:39 AM

Hey,

You could be out of memory

Try at the top of your macro.

Please Login or Register  to view this content.

Hope it helps

**smurray444** · 07-24-2007, 10:39 AM

Thanks for the suggestion. I tried that but the code seemed to do nothing (i.e. it just returned to a blank workbook).

I tried Googling about this error, and it does seem that it might be linked to a lack of memory. However, I'm using a PC with 4GB of RAM - the text file in question is 84MB.

Any other pointers guys?

Thanks again.