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

Save failure after VBA macro
 

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

Save failure after VBA macro
 

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