Please me with my excel file?

I would appreciate if somebody can help how to write excel vba code for what I want. I want that when a user closes the workbook because he is finished updating it, excel automatically creates a copy of the workbook in an folder named Archive Files in drive C. Thanks in advance.