Hi Team,

Good Day!

Currently I am working on a automation by using excel macros, and I have given the requirements below.

o To fetch the file names and the count of files under a parent folder.

o The Parent folder will bear multiple sub folders and these subfolders will bear images in PDF, TIF …etc. formats; The tool will need to list down all the files, its count and its format.

o The tool should have the “source” and “destination”, path. The “Copy”, “Move”, “Delete” function should be included in the tool. This will help us to move the defined files to be moved, copied or deleted that are listed in the tool.

I have created a template for this and I have got the file name and the destnation folder. File name will start from A9 and In Column E have given a data validation where we can select move or copy or delete files . Based on the selection the macro should perform the required action. Column C9 refers to file pathm and Column D9 referes to Destination path.
I have attached the file for your reference.

Capture.JPG
Please help me on this.File Listing Tool -V1.xlsm