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?
|