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.