Thread: ontime method?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
max max is offline
external usenet poster
 
Posts: 8
Default ontime method?

I created a macro that looks something like this:


Sub Macro7()

Application.OnTime TimeValue("07:00:00"), "Macro4"

End Sub


It works when I start it manually. Where would I insert the lines
relating to the Starttimer function so I can have the macro start
automatically each day? I looked at the related info on the Pearson
site but don't see how I would apply it to my situation. This is my
first experience with Excel macros and VBA.