Backup only one worksheet
 

Hi to all
How i take a backup of only 1 worksheet name "data", in new workbook and
when i take backup next time it should goto same file.

any help

Thanks

Tiya

Backup only one worksheet
 

Worksheets("Data").copy
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs "C:\MyBackups\Myfile.xls"
Application.DisplayAlerts = True
Activeworkbook.Close SaveChanges:=False

--
Regards,
Tom Ogilvy


"Tiya" wrote:

Hi to all
How i take a backup of only 1 worksheet name "data", in new workbook and
when i take backup next time it should goto same file.

any help

Thanks

Tiya