Excel -- Macro to Save XLS # of times
Posted on 2013-12-12
In Excel, I've have a graph with a data series linked to a RANDBETWEEN function (cell range).
As designed, each time I click, e.g., the "Save" icon, the random function regenerates its value set and therefore the graph is updated. This works great.
I now would like to add the following elements to the spreadsheet.
1. Have a cell (e.g., A1) that contains a drop-down box (values of, e.g., 10, 20, 30, etc.)
2. Add a command button that calls a macro
3. Macro's purpose is to save the Excel spreadsheet n time of times (as specified in the drop-down menu). So, if cell value in A1=10, then clicking on the macro will save/re-save the XLS 10 times. Therefore, the linked graph gives the appearance of being animated.
The execution of the save should be driven by a time factor. For example, based on another cell value, I want the save/re-save to occur every second or every two seconds. (Otherwise, if the Excel would execute in mili-seconds, it probably would defeat the purpose.)
I'm flexible to other suggestions... as long as the envisioned process allows to specify, e.g, the refresh of the random function to occur every # of seconds.
Any recommendations how to achieve this?