Using Now as a StartTime

Hi Folks,

I have a macro that activates between times.

The problem I have is that the StartTime has to be in the future. If the StartTime has passed the SchedTimer doesn't run. (See Red Text in Code)

Has anyone any ideas on how I can fix it so I can run SchedTimer without having to change the StartTime?

Thanks

Please Login or Register  to view this content.

.
Maybe (my guess) : Public Const StartTime As Date >= #3:32:00 PM#, EndTime As Date <= #9:30:00 PM#

Hi Magicman

Your macro runs every 3-minutes, i.e. 20 times per hour, starting at 3:32pm.

Assuming your PC gets turned on late, i.e. after this normal 3:32pm 'StartTime' , then maybe what you are asking for is for your macro to begin at the next 3-minute 'slot'.

For example, if the PC is switched on at 4:00pm, then maybe you want the macro scheduling to begin at 4:02pm ????

Maybe something like this..

Please Login or Register  to view this content.

..I haven't tested this

zeddy

Hi,

Try adding the code in red below. It's brute force, but the technique is simple and has always worked for me.

Please Login or Register  to view this content.

Lewis