Application.OnTIme
Did you run Timer?
In article ,
"Mike" wrote:
hi,
I created a copy macro within Excel that I need done at a
certain time each day. The copy macro (called copy3) is
under the Modules portion in Visual basic.
I put the following in the Sheet2 page in Visual basic:
Private Sub Timer()
Application.OnTime TimeValue("13:00:00"), "copy3"
End Sub
And it does not run the macro at 13:00.
What have I done wrong?
|