save and replace
 

I have several workbooks that I keep read only copies of on the network. Is
there a way to use vba to automatically replace the old version with the new
version when I close the working copy that I keep in my personal directory on
the network?
Using Excel 2000