HELP - Job at stake !

[JOEL-S]

I am a systems person and not a programmer. I need to have an MS EXCEL template that will automatically save itself every 5 minutes.
If I don't get this done today, I am FIRED !

Please assist.

We have two different workstations - one has MS EXCEL 2003 and the other MS EXCEL 2007 - I can upgrade the EXCEL 2003 to MS 2007 so if the template can be in MS EXCEL 2007 I would be forever grateful.

Joel

 

[VoG]

This is the solution. In the ThisWorkbook module

Private Sub Workbook_Open()
Application.OnTime Now + TimeValue("00:05:00"), "MyMacro"
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)       
Application.OnTime dTime, "MyMacro", , False 
End Sub

In a regular module

Public dTime As Date

Sub MyMacro()
dTime = Now + TimeValue("00:05:00")
Application.OnTime dTime, "MyMacro"
ThisWorkbook.Save
End Sub

 

[Smitty]

Maybe there will be someone who is willing to code the solution for me for a small reasonable fee.

consult @ mrexcel.com