I need a macro to change my sheet name.

When i open my workbook it allways have a different sheet name everyday(the
sheet names are not constant) so i need to change it to as i require (change
to Rec), i my workbook i will have only one sheet.

I'm not sure I understand why your sheet's name changes; but, since you only
have one sheet in the workbook, you can just assign whatever name you want
to the Name property of the ActiveSheet...

ActiveSheet.Name = "Rec"

--
Rick (MVP - Excel)


"Ranjith Kurian" <(E-Mail Removed)> wrote in message
news:47B42407-6D05-4003-A860-(E-Mail Removed)...
>I need a macro to change my sheet name.
>
> When i open my workbook it allways have a different sheet name
> everyday(the
> sheet names are not constant) so i need to change it to as i require
> (change
> to Rec), i my workbook i will have only one sheet.