I have a space delimmited text file. I have read up on how to import
this using VBA and come across the script at this site
http://www.cpearson.com/excel/imptext.htm
This worked great until I imported a text file with 32767 rows in. (I
doubt it is coincedence that this is exactly 50% of the top limit)
I don't think the results will ever be over the limit of 65536 so I do
not need to use any error checking for that.
Basically I get an error stating "Runtime Error 6 Overflow" and when I
stop the macro I notice all text has been imported up to row 32767
Can anyone help?
Thanks if you can
Dan