save to multiple locations simultaneously
 

I save the same file to separate drives for several departments. When I save
changes to the spreadsheet that I work on in My Documents, is there a way to
automatically save the changes to the files that are on the other drives?
I've been doing it manually (saving changes to the file I'm working on in My
Documents, and then "Copy this file" to the other drives -- Replace the file
by that name) and occasionally overlook one, and then that department has
outdated information. Not to mention it's time-consuming to have to copy the
file repeatedly to all of the locations. I have Excel 2007, but have to save
in 97-2003 Compatibility mode. Any help, even if it is to tell me that it
can't be done, is appreciated!

save to multiple locations simultaneously
 

In VBA, the SaveCopyAs command saves the file under a different path/name
than the active file's path and name. You should be able to specify file
type as well.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MOSwannabe" wrote in message
...
I save the same file to separate drives for several departments. When I
save
changes to the spreadsheet that I work on in My Documents, is there a way
to
automatically save the changes to the files that are on the other drives?
I've been doing it manually (saving changes to the file I'm working on in
My
Documents, and then "Copy this file" to the other drives -- Replace the
file
by that name) and occasionally overlook one, and then that department has
outdated information. Not to mention it's time-consuming to have to copy
the
file repeatedly to all of the locations. I have Excel 2007, but have to
save
in 97-2003 Compatibility mode. Any help, even if it is to tell me that it
can't be done, is appreciated!