Time of Day Update
 

I can not get the program to run. I have the OnTime just
as I showed you. Once I compile it and save then I close
the VB editor and just have the spreadsheet open. Then I
minimize the spreadsheet. This is how it will be run.
It will not open the spreadsheet "C:\Documents and
Settings\Robert McMahon\My Documents\Macro Program for
Reports.xls" I have adjusted my program even to remove
the TimeValue and try to input ".5" as the time for excel
and it still will not work. If I can figure this out I
am going to alter this program to run Every hour. And
another one that will run every 15 minutes. But I can't
seem to get this one to work first.......Here is where I
am....
Sub a()
Application.OnTime TimeValue("12:00:00"), "Test"
End Sub

Sub Test()
Workbooks.Open "C:\Documents and Settings\Robert
McMahon\My Documents\Macro Program for Reports.xls"
End Sub

Thanks for any help.