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

Posted on 2011-10-03
Last Modified: 2012-05-12
.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


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.
    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.
    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 

    Open in new window

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

    Open in new window

    Hope this helps!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    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…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now