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 ***

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 ***

Jim,

The articles talk about 80 mBytes for Excel 2000 whereas
Application.MemoryTotal says only 1.5 mBytes. Am I missing some setting
to increase the memory available to Excel?

Thanks



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

Take a look at your Task manager to get a good handle on usage. Some
operations just use a lot of memory.
--
HTH...

Jim Thomlinson


"Edward Ulle" wrote:

Jim,

The articles talk about 80 mBytes for Excel 2000 whereas
Application.MemoryTotal says only 1.5 mBytes. Am I missing some setting
to increase the memory available to Excel?

Thanks



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

http://www.decisionmodels.com/memlimitsb.htm

"Edward Ulle" wrote in message
...
Jim,

The articles talk about 80 mBytes for Excel 2000 whereas
Application.MemoryTotal says only 1.5 mBytes. Am I missing some setting
to increase the memory available to Excel?

Thanks



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