File Manager Tool


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

VBA Tool to Delete or Move Files

Follow the below steps to use this tool:

1. Open the tool and select Source Folder
VBA Tool to Delete or Move Files
2. If you want to move few files on another place, then you need to also select destination folder
VBA Tool to Delete or Move Files
3. Now you are ready to use the tool, click on ‘Read File Details From Folder(s)’ button
VBA Tool to Delete or Move Files
4. Tool will now list down all the files available in the Source Folder and Sub-Folders (if option selected)
VBA Tool to Delete or Move Files
5. Now select the option for action to be taken in column G (Action to be Taken)
VBA Tool to Delete or Move Files
6. Once you are ready, click on ‘Delete or Move File(s)’ button
VBA Tool to Delete or Move Files
7. Done, tool will start taking the actions and will update the status column (Column H)
VBA Tool to Delete or Move Files
Prerequisite

You need to have installed version of MS Excel 2007 or above

Limitations:

If tool is not able to take required actions, then status column will be updated as Failed along with the error details

Add To Cart
VBA Tips you Must Know – Part 1
VBA TRICKS
Excel VBA Tips you Must Know – Part 1

Here we are coming with one more exciting post which can help you to solve very basic but very important problems while writing VBA codes.

How to use Excel Workday Formula in Excel
DATA ANALYSIS TRICKS
EXCEL FUNCTION – WORKDAY

Are you working today? or Do you have Work Off or holiday today?  I am asking this question because I am gonna tell you the most commonly used function in Excel “Workday”. “Workday” as name suggest that it brings the day when you will be working or you are expecting …

Subtotal Function Excel
DATA ANALYSIS TRICKS
Excel Function – SUBTOTAL

Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use this function for different purposes instead of multiple functions i.e. SUM, AVERAGE, COUNT, MAX, MIN, Standard Deviation etc. …

error

Like the Article? Please spread the word :)

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn