Macro to rename sheet when original sheet name is always different

[dgsarnow]

I have a report that is run in an external tool and produces an Excel file. The file contains 1 sheet, and that sheet is always named something different because a timestamp and some other variables are used to generate the sheet name. I want to use a macro to clean up the report and rename the sheet that is provided to "Data".

Is there a way I can do this as part of my macro or do I have to rename the sheet manually and then start my macro?

 

[Joe4]

Welcome to the Board!

In your Macro, when you sheet is active, you can easily rename it like this:

ActiveSheet.Name = "Data"