Hello,

I am using Excel 2007 I have a folder called "Reports" containing about 20
Excel workbooks. The file names are unique in the "Reports" folder for
example "Div(01).xlsx, Div(02).xlsx, DivGroup(01).xlsx" What I like to do
is move particular files into a respective folder by the number containing
within the parenthesis. For example there will be a folder call "Div(01)
Budget" I want to to move all the Excel files from the "Reports" folder
that contains the number within parenthesis Div(01).xlsx, DivGroup(01) into
the "Div(01) Budge" folder. Like wise for the other Excel files that
contain different number within the parenthesis for example"Div(02)" will go
to the "Div(02) Budget" folder, etc. I have seen VBA codeing using dates to
move the files, but I want to use the parenthesis. How do I do this? Any
tips or website to visit will be appreciated. Thank you in advance.

Cheers