Excel 98: vba insufficient memory

R

ralf

I have an excel application that works fine with windows xp, but when I try
to use it under imac os 9.1, it tells that there is no enough memory. How
can I handle this ?

thanks
 
F

Fredrik Wahlgren

ralf said:
I have an excel application that works fine with windows xp, but when I try
to use it under imac os 9.1, it tells that there is no enough memory. How
can I handle this ?

thanks

There's a 64 kb limit on the mac. The compiled code can not excced this
number. You have to rewrite the code so that it becomes smaller. Tru yo
identify the places where ypou do the same things over and over. Encapsulate
the functionality in a Sub or a Function.

You may want to submiyt your code so that others may make suggestions.

/ Fredrik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top