+ Reply to Thread
Results 1 to 2 of 2

automatic running macro daily using ontime method

Hybrid View

  1. #1
    Registered User
    Join Date
    11-05-2010
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    59

    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
    Sub Scheduler()
        Application.OnTime TimeValue("10:00:00"), "Main"
    End Sub
    is it going to run macro "Main" only once today at 10am, or is it only to run daily at 10am??

    Thanks
    YP

  2. #2
    Forum Contributor wallyeye's Avatar
    Join Date
    05-06-2011
    Location
    Arizona
    MS-Off Ver
    Office 2010, 2007
    Posts
    308

    Re: automatic running macro daily using ontime method

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1