Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Excel opens my file and a book1.xls, make it stop? | Excel Discussion (Misc queries) | |||
Make a text file from Excel workbook | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |