Sign in
 
Home20132010Other VersionsLibraryForumsGallery
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
TechCenter >
> 
> 
Is it possible to have excel 2010 delete files in a specific directory?

Answered Is it possible to have excel 2010 delete files in a specific directory?

  • Friday, April 06, 2012 8:50 AM
     
     
    Sign In to Vote
    0

    I have an addin for excel called TM directory listing: http://www.tushar-mehta.com/excel/software/dirlist/index.html, it's great for listing exactly down to the last file it has a bunch of useful info that it lists also about each file. However now i have two folders filled with 1 having 6000 and another with over 300 files. What i'm trying to achieve is to have:

    1. Both folders listed (i know how to do this), each will be on a separate sheet 
    2. A v-lookup to highlight any duplicates between the two sheets.
    3. Then to allow me to delete cells in the sheet I choose and that in turn deletes the specific file. 

    Thanks in advance for the helping hand, in the future I hope I can in turn answer someone else's question's. 

    I have asked the creator of this addin also.
    • Edited by A-Rahman2011 Friday, April 06, 2012 9:04 AM Minor edit
    •  
     

All Replies