Here is a link to an excellent resource on Memory Limits in Excel. Perhaps
there is something in here to answer your question.

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

Jim Thomlinson


"pinkyundbrain2000" wrote:

System: WinXP Home; Excel 2000 pro

I'm using a vba macro to import ascii code from files into a xls sheet.
The macro works good, but if more data is imported the excel gets out
of memory. I'm not over the 65536 rows and 255 coloums (i make new
sheets before this happens).

my question is: is it possible to save data on a sheet, and get the
information on that sheet out of the system memory?