Autosave macro with time stamp

Hi guys,

I have browsed through the threads for this topic, but as Im not really a VBA user, Im lost and would like to ask you for help creating a macro for an autosave.

I would need an autosave each 8 hours with date/time stamp and specific folder.

If you need any other info, please let me know

Many thanks in advance!!
Lukas

Hi there,

Copy the following code into the "ThisWorkbook" VBA CodeModule of the workbook you want to backup, and see if it does what you need:

Please Login or Register  to view this content.

The highlighted values can be altered to suit your own requirements.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Originally Posted by Lugashz

Hi Greg,

I`ve some questions:
- does the file needs to be opened, so that it works on the 8 hours basis?
- Im getting an error...attached right at the beginning of the code
- so that I can check it and not wait x hours, can i set the time interval for e.g. 0.1 hours?

Thanks!
Lukas

..I have handled the error with Option Explicit (I have moved it to the top) , but getting a different error... which I cant handle :/

Hi again,

1. Remove the "Sub autosave()" statement completely.

2. You can use whatever value you want for the dINTERVAL_HOURS constant (it is declared as being of type Double, so it does not have to be an integer value). Use a value of 0.000694 (i.e. 1 / 24 / 60) to create a backup copy at one-minute intervals.

3. Timing starts as soon as the workbook is opened. When the specified time interval has elapsed, a backup copy will be created.

4. If the workbook (but NOT Excel) is closed, it will be re-opened automatically when the specified time interval has elapsed. If Excel itself is closed the timing process will be stopped and the backup copy will not be created.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Greg,

after your explanation of how should it work, I think I need a different approach.

Is there any chance to make a back up copy at specified time even if the workbook is closed?

BTW - if I delete the "Sub autosave()" statement, the macro name disappears from my macro list.

Thanks again,
Lukas