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

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

"Allan" wrote:

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

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

Alok Joshi

"Alok" wrote:

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

"Allan" wrote:

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

Microsoft has a macro solution that does something similar:
http://support.microsoft.com/default...;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.

Allan wrote:

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

--

Dave Peterson

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

"Dave Peterson" wrote:

Microsoft has a macro solution that does something similar:
http://support.microsoft.com/default...;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.

Allan wrote:

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

--

Dave Peterson