Excel has a function, everytime when I save the file, it will create a
backup. However, does anyone know how could I specify the location for my
backup file? Thank you very much.

Excel uses the same folder as the workbook.

You can't change this. But you could write your own macro that would save the
file in multiple locations.

Tony wrote:

Excel has a function, everytime when I save the file, it will create a
backup. However, does anyone know how could I specify the location for my
backup file? Thank you very much.

--

Dave Peterson

Dave, just for my curiosity.......could you take this one step further?

you could write your own macro that would save the
file in multiple locations.

All I need is a Yes or No answer (no code necessary!), could this be done
with VBA:

Do an on save event procedure that verifies the active file was saved as a
backup, copies it to a new location then deletes the backup in the default
directory?

I need to learn me some VBA!

Biff

"Dave Peterson" wrote in message
...
Excel uses the same folder as the workbook.

You can't change this. But you could write your own macro that would save
the
file in multiple locations.

Tony wrote:

Excel has a function, everytime when I save the file, it will create a
backup. However, does anyone know how could I specify the location for
my
backup file? Thank you very much.

--

Dave Peterson

You can also specify the autorecover file location under
Tools/Options/Save

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=527932

Yes.

You could use an application event that looks for any workbook being saved (not
relying on autosave or autorecovery) and saves a copy of the file anywhere you
want.

You could also use an individual workbook's _beforesave event that does the same
thing.

Or you could just create macro that saves the file and also creates a backup
copy.

Then assign that macro to a shortcut key and use that whenever you wanted a
backup.

(I like the last technique best.)



Biff wrote:

Dave, just for my curiosity.......could you take this one step further?

you could write your own macro that would save the
file in multiple locations.

All I need is a Yes or No answer (no code necessary!), could this be done
with VBA:

Do an on save event procedure that verifies the active file was saved as a
backup, copies it to a new location then deletes the backup in the default
directory?

I need to learn me some VBA!

Biff

"Dave Peterson" wrote in message
...
Excel uses the same folder as the workbook.

You can't change this. But you could write your own macro that would save
the
file in multiple locations.

Tony wrote:

Excel has a function, everytime when I save the file, it will create a
backup. However, does anyone know how could I specify the location for
my
backup file? Thank you very much.

--

Dave Peterson

--

Dave Peterson

ps.

Jan Karel Pieterse wrote an addin (works in any version) called AutoSafe (note
spelling).

It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them in the recycle bin). And the user can always restore the backups from the
recycle bin.

http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)

Jan Karel's version will know if there was a crash and prompt you to open the
last version it saved.



Biff wrote:

Dave, just for my curiosity.......could you take this one step further?

you could write your own macro that would save the
file in multiple locations.

All I need is a Yes or No answer (no code necessary!), could this be done
with VBA:

Do an on save event procedure that verifies the active file was saved as a
backup, copies it to a new location then deletes the backup in the default
directory?

I need to learn me some VBA!

Biff

"Dave Peterson" wrote in message
...
Excel uses the same folder as the workbook.

You can't change this. But you could write your own macro that would save
the
file in multiple locations.

Tony wrote:

Excel has a function, everytime when I save the file, it will create a
backup. However, does anyone know how could I specify the location for
my
backup file? Thank you very much.

--

Dave Peterson

--

Dave Peterson

And one more hint.

Take a look at .save and .savecopyas in VBA's help.

Dave Peterson wrote:

Yes.

You could use an application event that looks for any workbook being saved (not
relying on autosave or autorecovery) and saves a copy of the file anywhere you
want.

You could also use an individual workbook's _beforesave event that does the same
thing.

Or you could just create macro that saves the file and also creates a backup
copy.

Then assign that macro to a shortcut key and use that whenever you wanted a
backup.

(I like the last technique best.)

Biff wrote:

Dave, just for my curiosity.......could you take this one step further?

you could write your own macro that would save the
file in multiple locations.

All I need is a Yes or No answer (no code necessary!), could this be done
with VBA:

Do an on save event procedure that verifies the active file was saved as a
backup, copies it to a new location then deletes the backup in the default
directory?

I need to learn me some VBA!

Biff

"Dave Peterson" wrote in message
...
Excel uses the same folder as the workbook.

You can't change this. But you could write your own macro that would save
the
file in multiple locations.

Tony wrote:

Excel has a function, everytime when I save the file, it will create a
backup. However, does anyone know how could I specify the location for
my
backup file? Thank you very much.

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson

Thanks Dave. You da man!

Biff

"Dave Peterson" wrote in message
...
And one more hint.

Take a look at .save and .savecopyas in VBA's help.

Dave Peterson wrote:

Yes.

You could use an application event that looks for any workbook being
saved (not
relying on autosave or autorecovery) and saves a copy of the file
anywhere you
want.

You could also use an individual workbook's _beforesave event that does
the same
thing.

Or you could just create macro that saves the file and also creates a
backup
copy.

Then assign that macro to a shortcut key and use that whenever you wanted
a
backup.

(I like the last technique best.)

Biff wrote:

Dave, just for my curiosity.......could you take this one step further?

you could write your own macro that would save the
file in multiple locations.

All I need is a Yes or No answer (no code necessary!), could this be
done
with VBA:

Do an on save event procedure that verifies the active file was saved
as a
backup, copies it to a new location then deletes the backup in the
default
directory?

I need to learn me some VBA!

Biff

"Dave Peterson" wrote in message
...
Excel uses the same folder as the workbook.

You can't change this. But you could write your own macro that would
save
the
file in multiple locations.

Tony wrote:

Excel has a function, everytime when I save the file, it will create
a
backup. However, does anyone know how could I specify the location
for
my
backup file? Thank you very much.

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson