Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XY Plot Size of Marker | Charts and Charting in Excel | |||
chart size | Charts and Charting in Excel | |||
Print Excel charts in Word 2003 with fixed size | Charts and Charting in Excel | |||
Font size prints same size regardless of how I set it in Excel | Excel Discussion (Misc queries) | |||
Customize page size | Setting up and Configuration of Excel |