Importing Text File with more than 65536 rows

[Guest]

I am tring to import text files, into column A, but some files contain more
than 65536 rows. I would love to get the rest of the file in Column B if when
the file contains more than 65536 rows

 

[Guest]

Look at this link. Microsoft article explains how this can be done. You may
have to modify the code somewhat since you want the additional data to go
into column B rather than to the next sheet.

Alok Joshi

 

[Dave Peterson]

Microsoft has a macro solution that does something similar:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596
XL: Importing Text Files Larger Than 16384 Rows
(written for xl95, but has a note to change stuff for xl97+)

It actually puts the extra lines into a new worksheet, but I bet it could be
modified to go to the next column.

 

[Guest]

Oops did'nt give you the link!! However, I see that Dave has already provided
you the link.
http://support.microsoft.com/default.aspx?scid=kb;en-us;120596

Alok Joshi

 

[Guest]

Thanks to bith of you guys, the link helped perfectly.
Allan