Save failure after VBA macro

[Macrophile05]

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

[jose luis]

Does the Macro somehow deletes (kills) the file from disk?

Jose Luis

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

[Macrophile05]

Hi Jose Luis,

Good question, but no. I do not try to save or delete within the macro.
Another strategy I thought of was to turn off the Autorecovery option for the
file. No luck there, either. I might add also that I have inserted commands
in the macro at the end of each loop that clear out the clipboard...this does
not help, either...unless someone can tell me whether it has actually created
my overall problem.

--Macrophile05


"jose luis" wrote:

>
> Does the Macro somehow deletes (kills) the file from disk?
>
> Jose Luis
>
>
> Macrophile05 Wrote:
> > 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
>
>
> --
> jose luis
> ------------------------------------------------------------------------
> jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312
> View this thread: http://www.excelforum.com/showthread...hreadid=392963
>
>