R
Ron Cüppers
Hi All,
I just wrote the first macro that uses all the memory that excel has got;
running the macro and after a short time Excel displays 'Out of stack
memory' than displays 'Out of memory' and finally shuts down. To learn about
the memory usage I took a look at the Excel memory (free/udes/total) while
running different applications and open files, but the memory usage keeps
growing. Saving opened files helps but the used memory does not return to
the initial value. Closing and re-opening Excel seems the only way to
achieve this ?? Is it really this bad or am I overlooking some options !!
Thanks in advance, Ron.
I just wrote the first macro that uses all the memory that excel has got;
running the macro and after a short time Excel displays 'Out of stack
memory' than displays 'Out of memory' and finally shuts down. To learn about
the memory usage I took a look at the Excel memory (free/udes/total) while
running different applications and open files, but the memory usage keeps
growing. Saving opened files helps but the used memory does not return to
the initial value. Closing and re-opening Excel seems the only way to
achieve this ?? Is it really this bad or am I overlooking some options !!
Thanks in advance, Ron.