I'm trying to think of a way of storing a document in several places but having them linked so that either it can only be updated in one place or else updates anywhere flow into the other stored copies?
You could set up a .dat file and everynight run on the scheduler to update the other locations by deleting those files and copying the origional to those locations.
Come to think of it IF YOU WANTED TO use VBA. Post this in the vba forum but you could have a procedure that would run when you close the file. This procedure could then copy the current file to all the other locations.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.