Solved

# .tmp files generated by excel 2010 not getting deleted in shared folder

Posted on 2011-10-03
1,011 Views
.tmp files generated by excel 2010 not getting deleted in shared folder

The  permission has been given in the  following manner
1.owner of the excel file in the shared  folder can delete  the excel sheet but othere can read and write   no permiision to delete .

2.i want to delete the .tmp files which is created in the shared folder also want to be deleted

how can we do do this any idea

Thanks
suman

0
Question by:greensuman

LVL 19

Expert Comment

Other forums seem to indicate that disabling microsoft security essentials stop the tmp files from being made.
Could you check if this indeed is the case ?
Otherwise, you could investigate if an add-in causes the tmp files to be made by disabling all add-ins.
0

LVL 19

Expert Comment

i expect that the tmp files will be owned by the persons which were saving the excel file. You could either have an administrator delete the files or try to take ownership of the documents and delete them yourself.
0

LVL 20

Accepted Solution

With the permissions you have set this can only be achieved doing the following:

You could do this from the backend using VBScript or Batch File, and maybe setup a scheduled task on your server to execute the script every hour or so:

VBScript Example: DeleteTMPfiles.vbs
Dim fso

Set fso = CreateObject("Scripting.FileSystemObject")

fso.DeleteFile "D:\path\to\folder\*.tmp", True


Batch File Example: DeleteTMPfiles.bat
del /s D:\topleveldir\*.tmp


Hope this helps!!
0

## Featured Post

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…