How to create a back-up for excel file.

M

mavy

Hi All!

How do I create a back-up for an excel file? Something that will really say
that it's a back-up of another file. Not the auto-recover setting one?

Help!!!! And, have a great day!
 
B

-Bryan

The simplest way I could think of would be to "Save As" and add the word
back-up to the file name. You'd also be able to save it in a different
location at the same time.
 
M

mavy

I tried that before and looks good but some back-up of Excel files have that
arrow thing in their icon. How can you makea back-up like that? I am using
Excel 2003.
 
M

mavy

Hi!

I don't seem to have that capability since I'm suing 2003. When I do save as
it will ask me what filename to use already.
 
D

David Biddulph

You had already said that you were using Excel 2003, and that is how to
select the backup option on Save As.

Look for Tools at the top right hand corner of the dialogue box where you
choose your file name from Save As.
--
David Biddulph

"[email protected]"
Hi!

I don't seem to have that capability since I'm suing 2003. When I do save
as
it will ask me what filename to use already.
Click to expand...
 
M

Mark K

Now that I have "Auto Back Up" turned on for my Excel 2002 file, I want to
choose the location where the back up copy is to be saved. Currently, I'm
working with a file on a floppy disk but I want the back up copy to be save
 
D

Dave Peterson

You checked "always create backup" in that file|saveas|tools|General options
dialog?

I don't think you can change the location. But maybe you could create a macro
that does a .savecopyas to any folder you want.

Then just run that macro when you want.

The macro could look as simple as this:

option explicit
sub SaveTwice()
with activeworkbook
.save
.savecopyas "C:\mybackups\" & .name
end with
end sub

Change the folder location to what you need.

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)
 
Top