Auto Calc

[advmold]

Hello all,

I have a excel file that is ALWAYS open on a terminal computer. The excel file is a shared workbook and is used for scheduling porposes. What I need to happen is every day at 12:00am recalc the spreed sheet so that the date formulas that I am using get re-indexed. Is there a timmer function or something else I can try. I thought about scheduling a MS task to close and reopen the file but, if I can get excel to calc that would be great.

Thanks
Chris

 

[AgentSmith]

Have a look at:

Application.OnTime

in the help file. Should do exactly what you're after.

 

[Joe4]

Why not just have the Auto Calc feature of the Excel spreadsheet turned on?

Tool | Options | Calculation | Automatic

 

[advmold]

I have Tool | Options | Calculation | Automatic turned on but last night I left the file open all night and it did not go to the next day. I think that a change needs to happen in order for that to happen, or the auto calc feature.

 

[Joe4]

Ah, now I think I see what you are getting at. Check out Agent Smith's reply. I think that should do what you want.

 

[advmold]

Due to my ignorance of VB I am not sure how to make this work. I found a wep page that looks like it will do the job but I think I am missing something. This is what I got.
http://www.cpearson.com/excel/ontime.htm

Sub StartTimer()

RunWhen = Now + TimeSerial(0, 0, cRunIntervalSeconds)
Application.OnTime earliesttime:=RunWhen, procedure:=cRunWhat, _
schedule:=True
End Sub

Sub The_Sub()
'
' your code here
'
StartTimer

End Sub

What would be "MY CODE"???