View Single Post
  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

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?