Chamberlin, the ontime code is a seperate macro which could be in the same module as the one which you want to run at 6:00AM, as shown below.
Sub ontime()
Application.OnTime TimeValue("6:00:00"), "Test"
End sub
Sub Test()
Range("A1").Value = 10
End Sub
I...