View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul LeBlanc Paul LeBlanc is offline
external usenet poster
 
Posts: 7
Default 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