Creating macro to save a backup copy of the same file in a shared drive

I am running Microst Excel 2003 through Microsoft Front Page as I need to update to my website. I am using a shared network so my colleagues can also upload their web pages.

I want to run Excel through Front Page (web server) and AFTER I save the workbook I want to run a macro which saves the same file in a 'shared drive'.

Any ideas what code to use? And why does excel not remember this macro each time the excel file is opened through front page?

Thanks