Save A copy to another folder

[Lensmeister]

HELPPPP

Some moron has deleted a really important file on our network.

I have an old copy (now I need to go through a shed load of paper to update it). What I need is some serious bit of VBA that will do the following:

When someone closes the file it will ALWAYS prompt to save the file.
The VBA will then save it to it normal location.
The VBA will ALSO save it to another folder.

Please this is really needed ASAP if possible.