View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] danbowden@gmail.com is offline
external usenet poster
 
Posts: 4
Default Macro To Import Text File

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