#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Olivia Towery
 
Posts: n/a
Default Size Limits

I use the Excel Object to write a workbook from a sql db each month. This
month the data was extensive and it seemed to quit writing after so many
lines. Is there a way to program the script to continue to write regardless
of size?

--
Olivia Towery
Tower Internet Management


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Size Limits

There is a limit of 65536 rows in any worksheet. You would need to
count the number of rows written from your database, and when you
exceed this number start writing to another worksheet (or workbook).

Hope this helps.

Pete

Reply
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
XY Plot Size of Marker A Pragmatic Cynic Charts and Charting in Excel 4 May 2nd 06 02:55 PM
chart size zdenek Charts and Charting in Excel 0 February 9th 06 09:58 AM
Print Excel charts in Word 2003 with fixed size Phil Charts and Charting in Excel 1 November 3rd 05 04:24 AM
Font size prints same size regardless of how I set it in Excel Marcusmouse Excel Discussion (Misc queries) 2 May 26th 05 03:25 PM
Customize page size puzzled Setting up and Configuration of Excel 0 February 18th 05 05:41 AM


All times are GMT +1. The time now is 02:06 AM.

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"