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" <[email protected]> wrote in message
news:[email protected]...
> 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