I have an open workbook collecting data from anoher source upon either
autosave while editing (meaning I manually change an insignificant cell) or I
manually hit F9 (Calc Now). I would like it to automatically update
(Calculate the workbook). I have a module setup which is saving the workbook
automatically without edit, but this doesn't update the data (like Calc Now
does) (i.e. if I put the function NOW() in a cell on a worksheet, it returns
the current date and time. In order to see the time updated you must hit F9
or in Autosave mode, update any cell and upon autosave, it will update). Is
there code to immulate the F9 key being hit, without any manual intervention.
I'd like the workbook to update and save at pre-defined intervals all by
itself. Please help with update (calculate workbook function). It is my
intention to have this workbook updating and saving 24 hours a day, seven
days a week, 365 days a year (all by itself).

Thanks in advance for your help!
Liz