save to multiple locations simultaneously

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top