How do I make a backup file of my excel document?
I would like to make a backup file of some of my excel spreadsheets, onto my
second hard drive. How do I do that? |
Stella,
Simply choose the files, and use copy, select the destination folder, and select paste, all within Explorer. For future reference, you could use a macro that automatically saves files to two folders, along the lines of: Sub BUandSave() 'Saves the current file to a backup folder and its own folder Application.DisplayAlerts = False ActiveWorkbook.SaveCopyAs FileName:="D:\Excel Backup\" & _ ActiveWorkbook.Name ActiveWorkbook.Save Application.DisplayAlerts = True End Sub You could create a custom button on a commandbar and assign this macro to that button. HTH, Bernie MS Excel MVP "Starrystella" wrote in message ... I would like to make a backup file of some of my excel spreadsheets, onto my second hard drive. How do I do that? |
All times are GMT +1. The time now is 04:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com