Copy Files from One Location to Another folder or directory in Excel VBA help please.

I have a destination folder that has these files: PDFs, jpg, and doc, docx; the folder has different names for each file for example: TN12345678 090119, TN REQUEST 78945612, etc - basically the pretext of the file name varies, however there are always 8 numbers in the file I need.

Currently I just have to individually type in *12345678 or * 78945612 (for example) in the search bar in order to find the individual file I need and I repeat that process 10, 20, 30+ times depending on what I need to do.

Can someone write a VBA code so I can input just the 8 numbers I am looking for in a column in excel and copy the files from the source folder to a destination folder so I only have the files I need? Thank you in advance! This is with VBA ( Alt + F11)

Try this - Assume your value is in A1 and enter the folders where indicated.

Please Login or Register  to view this content.

Can you work with that?