vba codes save files to path

Hello,

Anyone can help me!!!

I have excel 2003 workbook that we used in daily transaction in our company.
There are many times that my colleagues close the file without saving it.

This is the filename 37week9.xls,
and this is save at this path, T:\daily\work\transaction

Anyone here have macro codes?
1.) I want this file that will automatically save in every 10 minutes without clicking save and also automatically close the excel file.
2.) If the file is closed this will save automatically.

Thank you very much.
Akou.

For the Every ten minutes, that's a built in function of Excel.
You want to go to Tools --> Options --> Save (tab) and then set the autorecover time. You may also want to make note of the path.

Also, for your second issue, if a document has been changed, An office application will prompt the user to save the document when they try to close it. So what you need to do is tell the staff to click yes when it asks if they would like to save changes on close.

Thank you excel_guy49...

I dit it already. I want to have a macro command.
I'm just a begginer in macro codes.

Can you please make me a code on this in macro command?


Thank you.