Save Data Every 1 minute

0

Hi there, I've been trying to find a way to get a Excel document to save every 1 minute automatically.

Any ideas Thanks

Answer
Discuss

Answers

0
Selected Answer

It's not difficult to do, but the one thing to mention about this is that if saving your workbook takes more than an instant, it can cause unwanted pauses in the operation of your workbook, so take that into account and test on sample files first. That said, this working well will depend on a number of factors.

Here is the tutorial that shows you how to run a macro at intervals:

Run Macro at Set Intervals

To do the saving you can useĀ ThisWorkbook.Save

Workbook.Save MSDN Article

Discuss

Discussion

Thanks
Dave1245 (rep: 6) May 22, '20 at 2:31 pm
Add to Discussion
0

There is a tutorial on this site. I see it advertised to the left of my posting screen. It's named "Run a Macro at Set Intervals in Excel". Set that progrm up to run every minute and let it execute a procedure that saves your workbook.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login