View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Macros crash, "Not enough memory"

YOU ARE A STAR, KIND SIR!!!!!.......that did the trick. I had to run it
twice tho, to take advantage of the second part of setting it as "last
working with Windows Me", but it's simple and easy to do and most of all,
WORKS PERFECTLY!!!

BTW, I have three versions of Excel on this machine and it must be done for
each version to make the program run in that version.

Thanks again Jim.....
Vaya con Dios,
Chuck, CABGx3




"Jim Cone" wrote:

http://support.microsoft.com/kb/313935/en-us
"Office Programs Stop Responding After You Upgrade to Windows XP"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"CLR"
wrote in message

I have every confidence that if I were to run the program on 100 more Me
machines it would work on every one of them, and if on 100 more XP machines
(if set up my our MIS dept) they would all fail. I don't use any forms. I
wouldn't know a "variant" or a "recursion" if they was to bite me in the
butt. Macros 15 and 16 are exact copies of the previous 10 macros with only
a couple of numbers changed to autofilter a different set of data out of the
database. If the code were "bad", it would seem that it would not run on the
Me machines either. All macros run, if run individually on the XP machines,
just not if ALL are run in sequence.

A puzzler....

Vaya con Dios,
Chuck, CABGx3