Auto Update after certain time period (60 sec)
How can I set up a workbook to automatically update the data it retrieves
from other sources every 60 seconds. I can update manually by pressing F9 but I would like it to be automatic. |
Have a look in vba help index for
ontime -- Don Guillett SalesAid Software "mrdelia" wrote in message ... How can I set up a workbook to automatically update the data it retrieves from other sources every 60 seconds. I can update manually by pressing F9 but I would like it to be automatic. |
Thank you,
I have tried OnTime with no success. It seems to update once and then stop. How can I get it to return to the OnTime statement. I tried GoTo but locked the spreadsheet up. "Don Guillett" wrote: Have a look in vba help index for ontime -- Don Guillett SalesAid Software "mrdelia" wrote in message ... How can I set up a workbook to automatically update the data it retrieves from other sources every 60 seconds. I can update manually by pressing F9 but I would like it to be automatic. |
You can read more about the scheduling procedures at Chip Pearson's site:
http://www.cpearson.com/excel/ontime.htm mrdelia wrote: How can I set up a workbook to automatically update the data it retrieves from other sources every 60 seconds. I can update manually by pressing F9 but I would like it to be automatic. -- Dave Peterson |
Thanks to all the info helped solve my problem.
Darin "mrdelia" wrote: How can I set up a workbook to automatically update the data it retrieves from other sources every 60 seconds. I can update manually by pressing F9 but I would like it to be automatic. |
All times are GMT +1. The time now is 11:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com