Macro to copy an excel file every 5 minutes automatically

[feni1388]

Hello..

I have an excel file that is created every day using vba. This excel file is being used by several users at the same time (shared workbook).
But only 2 users are allowed to make changes at the same time.
I'm not sure what the cause is, but lately this shared workbook can suddenly unresponsive and showing a message that the workbook is locked.
To prevent any loss in the information saved, I'm wondering whether I can use VBA to automatically save this excel file under different name every 5 minutes or so.
Once it's saved under that different name, the next 5 minutes macro can save it under the same backup file name.

I'm not good at creating VBA, so if anyone can help.....

Thank you in advance

 

[ranman256]

you shouldnt be sharing an excel workbook at the same time as others. (you've seen the results)
You CAN use Access database with multi users all editing different records.

 

[feni1388]

you shouldnt be sharing an excel workbook at the same time as others. (you've seen the results)
You CAN use Access database with multi users all editing different records.

You're right but the thing is that our office isn't equipped with Access and we have our own database already.
This excel thing is only for day to day record that are connected to another excel file.