And for sample2:

Windows("BASE" & Format(Date, "MMMDD") & ".xls").Activate

Does that help?
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Steve" wrote:

If have recorded a macro that selects various tabs ( sample 1)

and another macro that indicates the name of the file ( sample 2).

sample 1 Sheets(Array("MasterTab", "Data 10-28-09", "Tdata
10-28-09")).Copy

sample 2 Windows("BASEOct28.xls").Activate

Being that I rename the various tabs when I update them ( 10-29, etc), and
also save the file as the updated date (BaseOct29.xls), the macros do not
work because they're looking for the tabs with the 10-28 date, which have
been re-named 10-29, and same for the file. Is there a way to have the macro
work with the new dates ?

Thanks,

Steve