running macro on time not working

**SJDANIELS** · 07-31-2008, 07:22 AM

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"

**Richard Schollar** · 07-31-2008, 07:35 AM

Hi

try wrapping those times in the TimeValue function and adding today's date:

Application.OnTime Date+TimeValue("07:05:00"), "macro1"
Application.OnTime Date+TimeValue("07:09:00"), "macro1"
Application.OnTime Date+TimeValue("07:10:00"), "macro1"
Application.OnTime Date+TimeValue("07:12:00"), "macro1"

This should schedule Macro1 to be run at 7:05am, 7:09am, 7:10am and 7:12am of the current day.

Richard

**SJDANIELS** · 07-31-2008, 10:26 AM

Thank you
It is working fine. But why didn't the other way work.

**Richard Schollar** · 07-31-2008, 10:33 AM

VBA didn't recognise your string times as proper datetimes (I presume) and therefore may have simply run the macros immediately. This would be my guess anyway

Richard

running macro on time not working

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

running macro on time not working

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions