Results 1 to 2 of 2

Executing a macro at a defined time

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2008
    Location
    UK
    Posts
    5

    Executing a macro at a defined time

    I have a worksheet that is used to update daily events. I currently have a macro which is operated manually to send a copy of the worksheet to a defined mailing list.
    I would like to automate this process so that the worksheet is mailed at a defined time each day.
    I tried the following:
    Private Sub Workbook_Open()
     
        Application.OnTime TimeValue("16:16:00"), "Mail_sheets"
     
    End Sub
    But it doesn't seem to work?

    CW
    Last edited by VBA Noob; 02-13-2009 at 02:03 PM.

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