General discussion

  • Creator
  • #2091286

    Creating/problem with an Excel Object


    by mr hitman ·

    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

All Comments

Viewing 2 reply threads