Temp files not deleted from Spreadsheet's directory

[markf]

Temporary files named (Spreadsheet_Filename).xls~RF??????.TMP are been left in the Spreadsheet's directory after changes have been made and the Spreadsheet closed. No obvious behaviour pattern, other than it not occuring before a switch to WinXP/OfficeXP (2002), and this series of Spreadsheets including macros and linked data.

Any ideas on this, my usual Forum, before I muse over posting this query on a more Excel-based Forum?

[RobDog888]

Best guess is that there could be some macro code that is not
destroying objects correctly. So when Excel "closes" it doesn't get
the opportunity to destroy the temp files.

HTH

[BrianB]

I think it is a general system problem. We get that here even if no special macros are involved.

Make a DOS batch file to delete the files. Put this in Notepad :-

DEL *.TMP

.. and save as somename.bat. Doubleclick it in Explorer to delete all files in the same folder havinga .tmp suffix. The benefit is that it ignores .tmp files currently in use, so there is no errror message to cope with.

[RobDog888]

You may want to add to the bat file, the path to your temp dir. If
you accidentally run it from some place other than the temp dir, it
will delete the temp files there. With the path added you could
locate the bat file anywhere. Also, you could create a shortcut on
you desktop or quick launch bar.

Good idea BrianB