Hi there, I've been trying to find a way to get a Excel document to save every 1 minute automatically.
Any ideas Thanks
Hi there, I've been trying to find a way to get a Excel document to save every 1 minute automatically.
Any ideas Thanks
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:
To do the saving you can useĀ ThisWorkbook.Save
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.