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