VBA to re-name every first sheet and fill column header from P To U

Do you have other excel files in that folder that you do not want modified? If not, try this:

Please Login or Register  to view this content.

Try this
It will amend all files with extension .xlsb in the given folder

Paste this code into a standard module

Please Login or Register  to view this content.

@Kevin#
I think that:

Please Login or Register  to view this content.

should be

Please Login or Register  to view this content.

I love the file list at the end... I need to use that more often.

@spitfireblue Yes you are correct.
(I amended it as I replied - different in original)

Glad you like the file list. I often build up a message string. Very useful when building VBA too - used well it gives you a lot of info quickly in one place