Hi,

I have written some code that takes a large text file, performs a bunch of
manipulations and then puts the data in to a pivot table. This works fine
on 2000, 2003 and 2007. However, when the text file is more than 65536 rows
then obviously 2000 and 2003 have a problem - it works fine on 2007 however.
So is there a way to read in the text file and make it stop at 65536 rows
and put the rest onto another worksheet? This would be particularly useful
as the client I have written this for does not want to purchase 2007 if at
all avoidable.

Thanks in advance

Hi,

Chip Pearson describes how to do that here

http://www.cpearson.com/excel/ImportBigFiles.aspx

Mike

"Graham Whitehead" wrote:

Hi,

I have written some code that takes a large text file, performs a bunch of
manipulations and then puts the data in to a pivot table. This works fine
on 2000, 2003 and 2007. However, when the text file is more than 65536 rows
then obviously 2000 and 2003 have a problem - it works fine on 2007 however.
So is there a way to read in the text file and make it stop at 65536 rows
and put the rest onto another worksheet? This would be particularly useful
as the client I have written this for does not want to purchase 2007 if at
all avoidable.

Thanks in advance