I would guess that excel only builds temp files that it needs--so I'm gonna
guess you're not going to be able to do anything that will change excel's
behavior (and still keep excel useable, that is).
But...
Personally, I'd put a VBS script on a network drive and put shortcuts to that
VBS script on everyone's desktop.
This VBS script would clean the Temp folder (much easier than doing it
manually).
This is the one I use. It was written by Michael Harris:
http://groups.google.com/groups?thre...%40tkmsftngp02
Since there are lots of programs that write to the temp folder (and don't clean
up after themselves), I like the .vbs approach.
I just click on that shortcut after I close everything and am shutting down the
pc--or when I start it up--before I load any application.
========
Ps. I'm betting that those buttons on the worksheet are from the control
toolbox toolbar. Maybe you could replace them with buttons from the Forms
toolbar (you'll probably have to modify some code, too).
(I'd just click the shortcut to the .vbs file, though.)
FrankB wrote:
We're having problems with our users getting too many temp files
building up in thier temp directories. We're on Win98 and WinXP, the
problem is worse on 98, but still happening on XP. Our support people
are helping our users clean up their temp files to regainthe
performance, but I'd like to know if there's anything any one knows
that will stop this proliferation of temp files by Excel.
The files that seems to be primary culprits (these are variations on a
single master file) have from 20 to 40 sheets with about 8 buttons on
every other sheet. There is one UDF being used. The files all point
to a common VBA file for the code execution. Any ideas on what would
be the cause of all of the temp files or a method to manage their
growth outside of cleaning out the temp directory every two weeks?
--
FrankB
------------------------------------------------------------------------
FrankB's Profile: http://www.excelforum.com/member.php...o&userid=18952
View this thread: http://www.excelforum.com/showthread...hreadid=480679
--
Dave Peterson