Save A copy to another folder

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.

Not very serious but should do what you're asking:

Please Login or Register  to view this content.

Dom

Thanks Guys ... you are SUPERB