Out of Memory Error

[Arkansas Lady]

I am creating an Excel spreadsheet throught VBA. I have a formula that has
to add up many different lines. I store the formula into a string variable.
However, the string has almost 1,200 characters in it. When I go to post the
formula into the spreadsheet, I get a Run-Time Error '7' Out of Memory. This
has been working until a reached a large amount of data. Is there a way to
expand the memory? I can not use the sum formula.

Arkansas Lady

 

[Douglas J. Steele]

Sorry, this newsgroup is intended for questions about Access, the database
product that's part of Office Professional.

You'd be best off reposting this to a newsgroup related to Excel.

 

[Arkansas Lady]

Doug, I am using Access VBA to create the spreadsheet. My Out of Memory
Error is occurring in the Access VBA.

 

[JK]

Arkansas Lady,

Try to increase your Virtual Memory (In Windows)

Start->Settings->Control Panel->System->Advance->
(Performance) Settings->Advance
(Virtual Memory) Change

(You may have to restart you computer afterwards)

Regards/JK

 

[dbahooker]

no dude; MS Access just sucks.

use Access Data Projects... MDB doesn't leverage Ram; i've gotten this
error message before from Acces 97 on 10 mb of data; no cartesianing..
and I had 2gb of ram

Access MDB isn't reliable.. find someone to upsize this to SQL Server
for you

-Aaron

 

[Douglas J. Steele]

What's the code you're using to create the spreadsheet? How much RAM do you
have on the machine? What else is open at the same time? What versions of
Office and Windows are you using?