How can i handle more than 65000 rows in excel

[psk]

Hi,
I have written Some macros in Business objects to export to exce
sheet ..How can i handle if the output exceeds 65000 rows ..


This is the code we use in BO , But how can i handel i mean openin
workbook and sheet ..like that ..to split into sheets if it exceed
65000 and put it another one in the same workbook . Thank

 

[Gord Dibben]

If BO can be exported as a *.txt file.......

Importing text files larger than 65536 rows

http://support.microsoft.com/?kbid=120596

But, you may want to look at another application for that much data.

Access comes to mind.

Gord Dibben Excel MVP

 

[Guest]

The best way that I know of to make Excel get around the 65,000 row limit is
to dump the output into Access or something similar and then to either:

-query a result set into excel

-or to use a pivot table externally linked to the data. (I have
successfully linked to over 650,000 records in an Excel pivot table with
remarkably good performance)

 

[Paul Black]

Hi psk,

I do NOT know about "Business Objects" but in Excel you could use something like :-

If N = 65001 Then

N = 1

ActiveCell.Offset(-65000, 1).Select

Hope this Helps.
All the Best
Paul