Changing Sheet Name

[Andym]

Help.
I have a Macro that takes data from a Excel file which is saved automaticly
daily to the same location, however the sheet name changes every time. Is
there a way to make the macro select that sheet regardless of the name of the
sheet??

thanks

[Tom Ogilvy]

If it is the first sheet, you can refer is as index value 1

Worksheets(1).Activate

if the last sheet

worksheets(worksheets.count).Activate

--
Regards,
Tom Ogilvy

"Andym" <Andym@discussions.microsoft.com> wrote in message
news:D4C8E96E-128B-4381-B89A-869B70F384B6@microsoft.com...
> Help.
> I have a Macro that takes data from a Excel file which is saved
automaticly
> daily to the same location, however the sheet name changes every time. Is
> there a way to make the macro select that sheet regardless of the name of
the
> sheet??
>
> thanks