File Manager Tool

About the tool

Complete Excel VBA Course

File Manager tool is an Excel based tool which helps you to delete or move unwanted files from your system. It requires a source and destination folder (in case you want to move files). First it lists all the files available in the folder or sub-folders then you can select the action to be taken for each file such as Move or Delete. With a click of button, tool will take all necessary actions.

Tool Features

  • Read file details from folder and sub-folders
  • Move files from one folder to another folder
  • Delete files from folder and sub-folders

Benefits

  • Save time to get file details
  • Move or Delete files on a click of button
  • Save system space by deleting unwanted files

System Requirements

  • You need to have installed version of MS Excel 2010 or above

Tool Limitations

  • As the number of files increases, tool may take more time to move or delete files

How to use this tool

Follow the below video which details out how to use this tool.
  • Open the tool and you will see below screen
    File Manager Tool
  • If the macros are disabled, click on Enable Content button
    File Manager Tool
  • Click on Browse a Folder to select source folder where your files are placed
    File Manager Tool
    Note: Ensure to select right option to include or exclude sub-folders
  • If you want to move few files on another place, then you need to also select destination folder
    File Manager Tool
  • Now you are ready to use the tool, click on ‘Read File Details From Folder(s)’ button
    File Manager Tool
  • Tool will now list down all the files available in the Source Folder and Sub-Folders (if option selected)
    File Manager Tool
  • Now select the option for action to be taken in column G (Action to be Taken)
  • Once you are ready, click on ‘Delete or Move File(s)’ button
  • Done, tool will start taking the actions and will update the status column (Column H)

Recommended Articles

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *