I think this isn't an excel question--it's more about what your email program
does.

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

If you're not on a network, you could put the script in a local folder and still
put a shortcut to the script on the desktop.

(I don't like to put the real file on the desktop--it's too easily deleted.)

darrenrwood wrote:

I am receiving e mails each week which include a excel 97 spreadsheet. I then
open the spreadsheet and use it within excel.

However on occassions the file name changes from say "fredbloggs" to
"Fredbloggs1" and this seems to be because there is already a file ( albeit
not open ) named "frebloggs" in the temp folder from the last time i used it.

Is there a way to stop this number being added to the name or a way of
deleting the .xls files in the temp folder automatically when windows starts
?

Whatever the solution I need to keep it simple as others will be carrying
out this task who have very little pc knowledge. Its working on Windows NT.

And just in case it matters the reason i dont want the file name to change
is that there is a macro which chooses the spreadsheet by name and this fails
if the name is changed.

I hope this makes sense, any help would be very much appreciated

Darren

--

Dave Peterson