Results 1 to 4 of 4

running macro on time not working

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2008
    Location
    USA
    Posts
    11

    running macro on time not working

    I have tried 3 different ways to run a macro on time and all have done the same thing. the macro runs 2,3 or even 4 times when it executes.
    when I run the macro alone it works fine. when I run with just one line of code to start the macro it also works ok. but when I try to run more then one line to execute the macro the macro runs multipull times. Can any one fix this for me??

    Application.OnTime ("07:05:00"), "macro1"
    Application.OnTime ("07:09:00"), "macro1"
    Application.OnTime ("07:10:00"), "macro1"
    Application.OnTime ("07:12:00"), "macro1"
    Last edited by VBA Noob; 07-31-2008 at 07:39 AM.

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