General discussion

Locked

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

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Creating/problem with an Excel Object

by DKlippert In reply to Creating/problem with an ...

There is a KB article re Excel and passing arrays:
http://support.microsoft.com/support/kb/articles/Q177/9/91.ASP

Collapse -

Creating/problem with an Excel Object

by Mr HitMan In reply to Creating/problem with an ...

The web address you gave was invalid. took a sample of you web address and searched all articles that even closely matched your reply, but no help.

Thanks for any input. If you have another suggestion, please send.

Collapse -

Creating/problem with an Excel Object

by DKlippert In reply to Creating/problem with an ...

This is the right URL, they don't paste in very well. There s/b no spaces.
You can find the KB article by searching on WWW.Microsoft.com for Q177991.

http://support.microsoft.com/support/kb/articles/Q177/9/91.ASP

Collapse -

Creating/problem with an Excel Object

by Mr HitMan In reply to Creating/problem with an ...

Thanks for your help doug. This wasn't the answer, but you got me thinking in the right direction.

The problem:

tight looping prohibited the object from releasing memory alocated for object refernecing.

Fix: cut down on dot terms.

this limitation only exist in 95/98 office setup. Switching to NT or 2000 is a listed fix if you don't want to change your code.

One hit man to another

Collapse -

Creating/problem with an Excel Object

by Mr HitMan In reply to Creating/problem with an ...

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums