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

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" wrote in message
...
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