Renaming and saving workbooks but macro still deletes

S

shrek

I have a workbook which is linked to a summary via a paste special link.
I have also a macro set up to delete all the data in the input screens
which in turn delete the data in the summary.

Every month I have to save the data in the summaries. I at present Save
it as a new file name. When I delete the original workbook using the
macro it also deletes the data in the renamed file. Is there anyway I
can save the data in a new renamed file and then delete the data in the
original summary without it being deleted in the renamed file.
 
Top