Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro to recalculate every 10 seconds
I am trying to use an Excel worksheet as a backdrop to a rolling Powerpoint
presentation. Their is no human intervention with the sheet or the presentation once it is running. I need a macro to recalcualate the sheet every few seconds or at least once a minute to keep the presentation updated. The links all work, (Excel highlighted cells, Copy, Powerpoint, Paste special link) it is just the sheet update I need. The sheet will be running in the background and the macro could be manually started or an autorun when the workbook is opened. Many Thanks Paul Moles |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro to recalculate every 10 seconds
Public RunWhen As Double
Public Const cRunIntervalSeconds = 10 Public Const cRunWhat = "The_Sub" Sub StartTimer() RunWhen = Now + TimeSerial(0, 0, cRunIntervalSeconds) Application.OnTime earliesttime:=RunWhen, procedu=cRunWhat, _ schedule:=True End Sub Sub The_Sub() Calculate StartTimer End Sub Sub StopTimer() On Error Resume Next Application.OnTime earliesttime:=RunWhen, _ procedu=cRunWhat, schedule:=False End Sub begin by running StartTimer. The_Sub will run every 10 seconds. finish by running StopTimer. -- Gary''s Student - gsnu200801 "Paul Moles" wrote: I am trying to use an Excel worksheet as a backdrop to a rolling Powerpoint presentation. Their is no human intervention with the sheet or the presentation once it is running. I need a macro to recalcualate the sheet every few seconds or at least once a minute to keep the presentation updated. The links all work, (Excel highlighted cells, Copy, Powerpoint, Paste special link) it is just the sheet update I need. The sheet will be running in the background and the macro could be manually started or an autorun when the workbook is opened. Many Thanks Paul Moles |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro to recalculate every 10 seconds
see Chip Pearson's examples at
http://www.cpearson.com/excel/TimedClose.htm one possible solution might be to use those 2 macros (tested in Excel 2003 and they worked) Sub delay() runwhen = Now + TimeSerial(0, 0, 10) Application.OnTime runwhen, "recount", , True End Sub Sub recount() For i =1 to 100 Call delay Calculate Next i End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro wait 30 seconds then Complete the Macro | Excel Discussion (Misc queries) | |||
MACRO ACTIVATED EVERY 5 SECONDS | Excel Discussion (Misc queries) | |||
Converting Julian Seconds with a macro to replace old seconds data | Excel Discussion (Misc queries) | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
Can you make excel automatically recalculate every x seconds? | Excel Discussion (Misc queries) |