Recording data at a particular time

[mville]

Hi,
What is the code to take a snapshot for a particular cell at a given time?

Once you have the code, does your workbook have to be open to record the snapshot?

Thanks

 

[Jerry Sullivan]

the Application.OnTime Method can be used to do that.
Excel's VBA Help has a good description of how to use it.

Excel has to be open for the code to run and the Application that has the code has to be available. In other words, your workbook with the Cell to be recorded doesn't have to be open, provided you have Application.OnTime code in your Personal.xlsb or some other file that is open.