Excel VBA - Memory use on Mac

[Andy Keen]

I have written an App which runs fine on a Windows PC
(Win98 or XP) with 128 Mb or RAM

It immediately runs out of memory when run on a Mac of
similar spec with OS9. I have fiddled with the settings on
the Mac, and maybe I can solve it if I give Excel enough
memory, but I am not very knowledgeable about memory use
on the programming side. Is there anything I should be
looking for in my code which could be gobbling up memory?

Many thanks in advance, Andy Keen

 

[JE McGimpsey]

Unlike Mac OSX, Mac OS 9 doesn't automatically allocate more memory.
Instead, the amount of memory allocated to the app is set by what the
app asks for when the it starts. Unfortunately, MacXL98/01 both ship
with minimal memory allocations.

To increase memory available to MacXL98/01, with XL closed, select the
application icon in the Finder and choose File/Get Info/Memory. Increase
the "preferred" allocation by at least 5MB (I used to run at 30MB for
XL01). Leave the "minimum" setting alone.