Loop Through All Files In Folder And Delete As Per Condition

**calvinle** · 06-04-2015, 08:43 AM

Hi guys,

I have a folder containing about 500 different files, and I have a list of about 100 client that i need to copy the reports from those 500 different files to a folder.
Going through individually will take forever, and I have to do this every year.

1 thing is that all the files are named as per follow:
XXXXX_XX_CONTRACT#_BLABLA

In my excel list, I have a list of all the contract #(5 digits) to be pulled in column A.

So I am thinking if I can have a VBA file that can go through each file in a folder and if the contract# match the filename, then copy the file to another location.

Anyone can help out on this?

Thanks.

**xladept** · 06-06-2015, 05:27 PM

The path and a sample would clarify your need - so:

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**calvinle** · 06-07-2015, 01:06 PM

This is an example of the task to be done. Please note that the Second Path folder should be empty, then after clicking the Copy button in the VBA File, it will copy the 2 files from the Main Path folder to the Second Path folder.

See below attachment:
VBA.zip

Thanks.

**xladept** · 06-07-2015, 05:05 PM

Try this:

Please Login or Register  to view this content.

*Start with VBA File active

Loop Through All Files In Folder And Delete As Per Condition

LinkBack

Thread Tools

Rate This Thread

Display

Loop Through All Files In Folder And Delete As Per Condition

Re: Loop Through All Files In Golder And Delete As Per Condition

Re: Loop Through All Files In Golder And Delete As Per Condition

Re: Loop Through All Files In Golder And Delete As Per Condition

Thread Information

Users Browsing this Thread

Similar Threads

Choose folder & loop through all files to copy - folder is subfolder in network drive

[SOLVED] Loop through files in folder

VBA Loop for a folder of all the files, Loop all the worksheet in each workbook

loop through all files in a folder except for one of them

Loop through files in a folder

Bookmarks

Bookmarks

Posting Permissions