Amending various excel files including those in subfolders MACRO

Hi all

I have approx 500 excel files that i need to make the exact same changes to. As an explanation and for arguments sake i have copied the 500 files from a 2012 directory to a new 2013 directory for this year and every file is for a member of staff. It is a fairly simple deleting data and a year change in several cells.

Doing this manually will take days.

I've put the following together with just a simple updating of 3 cells to say "I am amazing". However I need this to run on all subfolders. My 2013 directory is then split into teams which each member of staffs excel document in each of those folders. I dont want to have to rewrite the macro below for each subfolder.

Any ideas how i can do this... and please keep it simple for me to follow as im not an excel whiz.

Please Login or Register  to view this content.

That is PERFECT!!

Being cheeky now.. but i have a similar issue as i need to rename each file from 2012 to 2013. The file name is normally "BSC 2012 PersonsName"

I have this which is exactly what i want but like the above it doesnt include subfolders. Could you amend to work like the above?

Please Login or Register  to view this content.

Literally cant thank you enough for this! This has saved me probably a weeks worth of work!! Thank you thank you thank you.

Oh last question. Not sure if its doable.

Is there a way to get the path in the macro to pull from the spreadsheet im running the macro from?

The code you have given above would need to be run every year, and i wouldnt want people playing with the code.

So could i have in cell A1 for example : C:\Users\Raff\Desktop\Test\ - and that is inserted into the code you have written?

Id want the same for old and new year..

Thanks again. I replicated that for the year too.