Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a back-up for excel file.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a back-up for excel file.
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a back-up for excel file.
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a back-up for excel file.
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a back-up for excel file.
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a back-up for excel file.
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a back-up for excel file.
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have saved over the top of my excel file and want to get it back | Excel Discussion (Misc queries) | |||
How do I get focus back on an Excel file? | Charts and Charting in Excel | |||
Excel 2000 back up file | Excel Discussion (Misc queries) | |||
SAVE is not available in Excel under FILE. How do I get it back? | Excel Discussion (Misc queries) | |||
How to I make a back up file in excel. | Excel Discussion (Misc queries) |