Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Starrystella
 
Posts: n/a
Default 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?
  #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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Excel opens my file and a book1.xls, make it stop? Bob Excel Discussion (Misc queries) 6 January 7th 05 12:20 AM
Make a text file from Excel workbook Ramana Murthy Excel Discussion (Misc queries) 7 January 3rd 05 05:37 PM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM


All times are GMT +1. The time now is 07:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"