Dave Peterson wrote:
Copy the code
paste into notepad
save as: deletetempfiles.vbs

double click on that when you want to clean the temp files.

(I actually put the .vbs file in a folder and put a shortcut to that .vbs file
on the desktop.)

But Dana DeLouis converted it so that it can be used in xl.

http://groups-beta.google.com/group/...932c72cef21fbe

or

http://tinyurl.com/djnys

davegb wrote:

Dave Peterson wrote:
That temp file can get cluttered pretty fast--maybe cleaning it every day???

I have a VBS script in a folder and a shortcut to it on my desktop.

Since there are lots of programs that fail to clean up after themselves, I like
to run it on demand--either right when I turn on the pc or right before I shut
it off.

It was written by Michael Harris:
http://groups.google.com/groups?thre...%40tkmsftngp02

davegb wrote:
<<snipped
I'm not too sure this fix is working. XL locked up on me yesterday
afternoon, not long after I cleaned out my Temp file. Will keep working
on it....

--

Dave Peterson

Thanks for the additional information. Since I don't know anything
about VB scripting, I wouldn't even know where to start to use that
code. Was wondering if there's a way to do that from Execl VBA so that
when XL is opened, it cleans out the Temp file?

--

Dave Peterson

Dave,
Finally got back to this. I can't run the VB script, my network system
won't allow it. And the link you posted was to a program to reset the
system clock. Do you know where the XL VBA program is to clean out the
Temp file?
Thanks.