How do I make a backup file of my excel document?

S

Starrystella

I would like to make a backup file of some of my excel spreadsheets, onto my
second hard drive. How do I do that?
 
B

Bernie Deitrick

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
 
Top