automatic running macro daily using ontime method

Hihi guys,

If I open my workbook at 9am, run the following sub and keep the workbook open

Please Login or Register  to view this content.

is it going to run macro "Main" only once today at 10am, or is it only to run daily at 10am??

Thanks
YP

I think you will need to have your Main routine call Scheduler when it completes. Even though you are not specifying a date, I suspect MS is prepending one within the Timer. I cannot find anything right off that indicates this behavior, but have found some references indicating that just specifying a time won't work.