Hi,

I am using a regular spreadsheet called tracker and every week it is
reset and the values entered are deleted
But before the table is deleted I would like to be able to save it
with as week range name. (ie jan28-Feb02.XLS)
I used record a macro to get the code but the problem with this is
that it also changes the open workbook file from Tracking.xls to jan28-
Feb02.XLS.

How do I save to a new name without changing the open file name?