VBA to copy files that contain certain text within filename from one folder to another

**NeilM** · 07-23-2013, 08:41 PM

Hi All,

I need a VBA that can go through a certain folder and copy files that contain a certain text into another folder. For example.

I have 100 PDF files in 'FOLDER A'

I need to go through 'FOLDER A' and find the PDF files that contain the word 'Sydney' and copy it in folder called 'FOLDER - Sydney'. Then find the files that contain the word 'Melbourne and copy it into 'FOLDER - Melbourne', and so on untill i have completed the string requirements.

If you can help me with this it would be great!!!!

Thanks Guys!

Below is a VBA i tried to manipulate, however it did not work and dont know how to loop it into another target folder.

Please Login or Register  to view this content.

- list of words i was looking for.

Please Login or Register  to view this content.

**patel45** · 07-24-2013, 02:54 AM

Please Login or Register  to view this content.

**NeilM** · 07-24-2013, 07:03 PM

Brilliant!

Thanks Patel45. Also

If i wanted to add more to this. say that now If i wanted to move all files that contain 'Melbourne' to 'FOLDER - Melbourne' (and so on)within the same VBA how do i add on the other requirements.

instead of just Sydney i want add on other requirements.

Sydney to FOLDER - Sydney
Melbourne to FOLDER - Melbourne
Brisbane to FOLDER Brisbane
etc.

If you can advise of the code to set for each location, i cna apply that to the rest.

Thanks Patel Appeciate it!

Neil.

**patel45** · 07-25-2013, 02:04 AM

Please Login or Register  to view this content.

**NeilM** · 07-25-2013, 02:38 AM

You have been a great help Patel45!

Thank you.

**aragorn25** · 03-27-2015, 06:28 AM

What in case |I have a list of files not one word?

VBA to copy files that contain certain text within filename from one folder to another

LinkBack

Thread Tools

Rate This Thread

Display

VBA to copy files that contain certain text within filename from one folder to another

Re: VBA to copy files that contain certain text within filename from one folder to another

Re: VBA to copy files that contain certain text within filename from one folder to another

Re: VBA to copy files that contain certain text within filename from one folder to another

Re: VBA to copy files that contain certain text within filename from one folder to another

Re: VBA to copy files that contain certain text within filename from one folder to another

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Code open files in folder, copy text to workbook-Next time folder opened copy only new

excel macro to copy data from multi text files in a folder to a single work sheet

open all files in a folder with fixed number of characters in filename

[SOLVED] Copy Files to other folder

[SOLVED] How to copy 30 csv files from a folder to another folder

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions