Changing Sheet Name
 

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

Changing Sheet Name
 

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