Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Ben Elliott" wrote: 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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" wrote: 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 -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Ben Elliott" wrote: 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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Ben Elliott" wrote: 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" wrote: 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 -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Ben Elliott" wrote: 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? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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/mic...1eecaad1c774cc 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/mic...cd4eed0638e395 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. Ben Elliott wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 slow closing files in Vista SP1 | Excel Discussion (Misc queries) | |||
Excel Not Deleting .tmp Files When Closing | Excel Discussion (Misc queries) | |||
Excel 2003/2007 Crash when opening/closing files | Excel Discussion (Misc queries) | |||
Closing Files | Excel Discussion (Misc queries) | |||
Closing files and saving files | Excel Worksheet Functions |