Rename excel file based on sheet name

[MarietjieT]

Good day, Thank you for the great forum! I was wondering if there is a quick way to rename multiple excel files according to the 1'st sheet name. I receive multiple files all named sheet 1, that I need to process for different customers. I currently rename them manually according to the sheet name ( which is the company name) as well as the date on which it was received? Can this be done with a Vba? Thank you

 

[Joe4]

Welcome to the Board!

Yes, this can be done, though we need more details.
When/how should this renaming occur?
Typically, I have seen scripts that run through all files in a folder, but that cannot be the case here, as you cannot have files in the same folder with the same name ("Sheet1").

And where is code going to be stored and run from?

And what folder will these files be saved in?