|
Automating the f9 (Calc Now) function key
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 |
Automating the f9 (Calc Now) function key
Hi Liz
Have you tried: application.Calculate Regards Rowan Liz L :) wrote: 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 |
Automating the f9 (Calc Now) function key
That was it. Thaks for the expertise!
Liz "Rowan Drummond" wrote: Hi Liz Have you tried: application.Calculate Regards Rowan Liz L :) wrote: 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 |
Automating the f9 (Calc Now) function key
You're welcome.
Liz L :) wrote: That was it. Thaks for the expertise! Liz |
| All times are GMT +1. The time now is 08:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com