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