Excel does not delete TMP files on closing. Why?

[Ben Elliott]

I find that Excel 2003 is not deleteing its tempoary files when it closes. Is
there a problem? How do I get it to do so?

 

[Satti Charvak]

Please see the following webpage:

Many people have this problem....there is one solution also (in vbscript)

http://www.pcreview.co.uk/forums/thread-2346607.php

 

[Ben Elliott]

I have copied the suggested code and saved it but cannot now see where Excel
can run such code. Any further suggestions?

Ben

 

[Satti Charvak]

Actually, you should copy the code to notepad and make a file with ".vbs"
extension and not the usual ".txt" extension. Save the file and close it.

Now just double click the file, it will run as an executable application.

Vbs file are windows os files and not connected directly with ms-office.

 

[Dave Peterson]

Are you positive that there is an extension (.tmp) on these files?

If the files really don't have any extension, then maybe something else is going
wrong.

Some background...

When excel (xl2003 and older) saves the file, it saves it as a temporary file
with a funny name (8 characters--no extension) in the same folder.

If the save is successful, xl will delete the original (or rename it to its
backup name (like "backup of book1.xlk)) and if that's successful, xl will
rename the funny named file to the original's name.

Maybe something is going wrong with that last rename step.

If you really do have that .tmp extension, do you run any AV software at all?
If yes, I'd try disabling it to see if the problem goes away.

Saved from a previous post:
==========

If those .tmp files look like: ...\VB*.tmp

I searched google again for "\vb" and .tmp and got a few hits.

One of them:
http://groups.google.co.uk/group/mi...caad1c774cc?lnk=st&q=&rnum=3#061eecaad1c774cc
or
http://snipurl.com/1339g

One person posted that they saw files that had names like: ~RF26c83af.TMP.

It was caused by AVG.

You can read her description in this thread:
http://groups.google.co.uk/group/mi...ct:autorecover"&rnum=2&hl=en#cccd4eed0638e395

or
http://snipurl.com/jyus

A while ago, someone posted back that uninstalling something called "Panda
ClientShield" fixed a similar problem.

Even if you're not running "Panda ClientShield", you could try disabling this
program to see if the problem goes away.

===============================
ps. I didn't remember correctly. That thread from Wendy (#7) does indeed point
to AVG as the culprit.