Move Files Based On date in Name

[erock24]

I'm looking for a macro that will move files from one folder to another based on the date in the name. For example, in my "SourceFolder" I will have files called "xxx-091009" and "xxx-091509". I need the 091009 version moved to my "DestinFolder". I would need this done for lots of files in the "SourceFolder". The file names will always be text, dash, 6 digit date. I used xxx to represent text.

I have code that lets me pick source and destin folders. Don't know how to move the files based on that condition.

Code to select folders (uses function below)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Charlize]

You could try something like this (go through your code with F8 to see if it does what it must do and use your mousecursor to see the results of myfile, sourcepath, ... etc) :

Please Login or Register  to view this content.

Charlize