How to create a back-up for excel file.

[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!

 

[-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.

 

[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.

 

[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.

 

[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

 

[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.)