View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MDW MDW is offline
external usenet poster
 
Posts: 117
Default 15 MB of Heap Space Too Much For Excel?

Starting yesterday, I've been getting a strange message telling me that
"Excel cannot complete the task with the resources available"....through
various research, I discovered the Application.MemoryUsed function. I've
popped it up at various sections of my code, and it shows that Excel is using
between 8,900,000 and 15,229,000 bytes...this latter number, if my
calculations are correct, translates to around 14.5 MB.

According to the article at http://www.decisionmodels.com/memlimitsc.htm, my
version of Excel (XL 2003) should have nearly a gig of space before I get any
errors.

So what's going on here?

--
Hmm...they have the Internet on COMPUTERS now!