excel 2003 VBA(macro)...Need HELP!!!

Joined
Sep 20, 2009
Messages
5
Reaction score
0
Hello,

Anyone can help me!!!

I have excel workbook that we used in daily transaction in our company.
There are many times that my colleagues close the file without saving it.
With this, I cannot recover the data that I had encoded.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top