View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How administrator can delete temporary excel file generated on se

I think you may want to reconsider your approach...

When excel saves the file, it saves it as a temporary file with a funny name (8
characters--no extension) on that same drive/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.

So as long as the users are supposed to be able to save their changes, they need
delete access to that server/folder to delete the original file.

=========
Those funny named files may be the ones that have the latest and greatest data
in it.



Suhas Sakalikar wrote:

We have denied the delete permission to the user on Windows 2003 server. Now
when user saves the excel file 8 digit alphanumeric temporary files get
generated without any extention where is in word it generated with .tmp
extention. Now as administrator we want to delete these temporary files from
all location with one go. Can you help us.


--

Dave Peterson