Creating/problem with an Excel ObjectLocked
I am programming in VB. i am creating an excel spreadsheet using an excel object.
I am using an oracle database as my datasource. I read in my data and create an Excel Object and start to build the Spreadsheet from my data.
When i create spreadsheets from smaller amounts of data, i have no problem. It creates the spreadsheet just fine. But when i use large amounts of data, i get an “out of memory” error.
Is there a size limitation on the excel spreadsheet object/excel/objectin memory?
Is there something memory wise i need to do when working with large amounts of data using an excel object?
Operating sys: 98
office verstion: 2000
VB version: 6.0