LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How can i handle more than 65000 rows in excel


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

--
ps
-----------------------------------------------------------------------
psk's Profile: http://www.excelforum.com/member.php...fo&userid=1573
View this thread: http://www.excelforum.com/showthread.php?threadid=27436

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Working with more than 65000 rows in Excel Nainar Excel Discussion (Misc queries) 1 November 26th 07 03:20 PM
how do I get more than 65000 rows to display in Excel 2007 Excel 2007 maximu rows Excel Discussion (Misc queries) 5 June 20th 07 05:22 PM
Please help me with microsofts code to convert more than 65000 rows from text to excel fari Excel Discussion (Misc queries) 2 June 21st 06 01:14 PM
Can I expand Excel workshhet beyond 65000 rows? Keith Excel Discussion (Misc queries) 3 May 21st 06 06:34 AM
How to get more than 65000 rows in and excel spreadsheet Jake Clark Excel Discussion (Misc queries) 3 October 25th 05 12:49 PM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"