Simple replace/rename directories and files?

[LanceBraun]

Good evening.

With an excel macro, how could I rename, a folder/subfolders along with files in each by
i) replacing the EstimateNumber with a JobNumber (the JobNumber exists in NextJobNum.txt)
ii) adding the job number to the front of all files within the directory and cub-directories.

I imagine this would be accomplished by by SELECTING the estimate number on a spread sheet and clicking a "Convert to Job button" (which would also change the selected cell to the value in the NextJobNum.txt file.

More Detail:
Our Estimate folders are created like this (always with a decreasing negative number, assuming an Estimate Number of -3432)

Est No. - Client - Product - Who Pays the bills

-3432 - JIM DAVIS - PEPSI COLA - UPSTREAM PRODUCTIONS

with subfloders:
-010 --3432 - CLIENT INFO - PEPSI COLA - JIM DAVIS
Schedule.txt
Job Description.txt
-020 --3432 - RENDERINGS -PEPSI COLA - JIM DAVIS
Client renderings.pdf
millions of pics.jpg
-030 --3432 - SHOP DRAW - PEPSI COLA - JIM DAVIS
and so on...

Each folder holds various files of job information

We would like them to read when finished (assuming the next job number is 8000):
8000 - JIM DAVIS - PEPSI COLA - UPSTREAM PRODUCTIONS
with subfloders:
-010 - 8000 - CLIENT INFO - PEPSI COLA
8000 - Schedule.txt
8000 - Job Description.txt
-020 - 8000 - RENDERINGS -PEPSI COLA
8000 - Client renderings.pdf
8000 - million of pics.jpg
-030 - 8000 - SHOP DRAW - PEPSI COLA

It is possible someone may have a file open when this macro is run - perhaps a warning with a delayed renaming try at 1AM? Or a warning on who has what file open and we can tell them to shut it?

Thanks gents. I again for the length of this.

LB

 

[hippiehacker]

looks more a vbs or powershell script why you need to run this in an excel Workbook?

 

[LanceBraun]

I'd like to use an excel macro.
There's a lot of specifics above. Let me rephrase:
I'd like to replace the first four digits of a directory name with a name in memory. I would like to look at all sub directories and do the same.

Sound doable?