Copy files of a certain file name length, extension & modification date to another folder

Copy only files of a certain file name length, extension & modification date to another folder

Is it possible to have a simple macro that would copy files of a certain fixed length, extension and ideally modification date. The file names needing to be copied are made up of 10 digits only, always have .txt extension and modified 2018 or newer.

Example file name: 1234567890.txt

If I could make this using recorded macro that is something I can maybe handle, not handy with VBA. Not very advanced user.
The .txt files reside in a folder named test and would like the files which meet the screening criteria copy to folder named qual.

Thanks j

Thanks for the suggestion CK76, however I'm not sure if I can figure out that. I was trying to understand the code, does it screen for the 10 character fixed length? - That is one of the key needs. I did not point it out but the desired files are mixed in with other type file types and various file name lengths.

-j

Thanks. I'm pretty raw at this but enjoy trying to learn it and figure things out. It appears the initial folder where the multitude of files resides is folder named Test and the folder where the selected files go is a subfolder named Dest. I think there is a edit needed, the second to last line, need to change .xlsb to txt?

Regards,

j

OK - I'll try to implement it. Thanks

Having trouble creating the macro correctly. Not sure what is needed to customize to my use. I did create the folder and sub folders and changed ".xlsb" to ".txt". I run the macro (I think) and there is no error nor are files moved as expected to the Dest folder. I'm very elementry when it comes to creating and customizing for my use.

Regards,

j

Thanks for the demo file - got it to work! One issue is it does not leave the original file in place. I tried to figure it out by replacing the MoveFiles command with CopyFiles but no luck. Thanks for your efforts CK76.

-j