Rename 1000 files cell O2

[CHC Consulting LLC]

I have a folder containing over 1000 excel files, all of which need to be renamed the contents of cell O2.

Is there a quick way to do this?

TIA

EDIT: Cell O2 is a merged cell. It is merged to column S.

 

[Norie]

You want to give 1000 excel files the same name?

 

[CHC Consulting LLC]

No O2 is a purchase order number and each one is different....

 

[Norie]

I know, I was only kidding.

The only way I can see this being done would be to open each file, get the name from O2 and either save with that filename or close the file and rename it.

Where are these files located?

All in one directory?

 

[CHC Consulting LLC]

Yes, all of the files are located in the same folder on the same drive.