Here is everything you want to know about Memory. There is also a good
section on perfomance and Calculations...

http://www.decisionmodels.com/memlimits.htm
--
HTH...

Jim Thomlinson


"Edward Ulle" wrote:

I am running into a problem loading data into Excel.

First is there a limitation on the number of Worksheets (i.e. 256)?

Secondly, I am getting the message Not enough memory. If I use
Application.MemoryTotal it says only 1.5 mBytes and MemoryFree 1.0
mBytes. Numbers seem very low by todays expectations.

I have not tried VBA for Access but would this get around the memory
limitations and could I program some thing equivalent to a Chart to plot
this data?

TIA



*** Sent via Developersdex http://www.developersdex.com ***