Move Excel files from One folder to another

Hi All

Here is my question.

I have multiple excel files in multiple folders. I need to move these files to another folder.

The multiple files I have - example:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I would then like to have folders bases on the first 4 digits, so:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Can this be achieved using excel? Anyone up for a challenge to help an old man ?

Many thanks

Originally Posted by Leith Ross

Hello yus786,

It can be done. Where will these new folders be located?

You star...

Would like a prompt box to enter the location. Most likely it will be X://month/

But if i have a prompt box, i can enter the path

Thanks again

Many thanks Leith, i await in anticipation

Hi there, any news on this my friend?