View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to create a back-up for excel file.

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

Mark K wrote:

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
on a hard drive. Does anyone know how to do this?

"David Biddulph" wrote:

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

"
wrote in message
...
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.
--
thank you!
Mavy


"David Biddulph" wrote:

Save As/ Tools/ General Options.
--
David Biddulph

"
wrote in message
...
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.

--
thank you!
Mavy


"-Bryan" wrote:

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.

" wrote:

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!
--
thank you!
Mavy







--

Dave Peterson