View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Macrophile05 Macrophile05 is offline
external usenet poster
 
Posts: 2
Default Save failure after VBA macro

I apologize if this is a double-post; my previous might have been lost.

After running a large VBA macro, Excel 2002 first says that it cannot save
the file because it cannot find it, providing three reasons why. Then when I
try to open a new file or save it under a different name, it says that it
cannot do it because there is not enough memory available, giving two
suggestions for correcting this. I have cleaned up my disk completely (temp
files, IE temp internet files and cookies), defragged, and I have increased
my pagefile initial and maximum to the recommended 3 GB (1.5 times RAM (2
GB)). Still, no luck. Suggestions? Thanks in advance.

--Macrophile05