Application.OnTime, Not Start, EveryTime ?

**keen2xl** · 10-26-2013, 06:21 AM

Hi Gurus

Have 7 Macros waiting to run "Application.OnTime TimeValue(Range("$X$9").Text), "WebPull"

Sometimes they run
Sometimes they don't

Looking on the Net came across

"if meanwhile another procedure is being executed and Excel is not in ready mode within 20 seconds, this procedure will not run."

"This means that the time when the procedure is to run (EarliestTime argument) should be assigned to a variable"

Trouble is me not know how to set up variables

Any assistance greatly appreciated as always you da men

Mike : )

Please Login or Register  to view this content.

**keen2xl** · 11-22-2013, 04:19 PM

This is a sad face : (

**keen2xl** · 11-29-2013, 03:08 PM

Ok Figured it out

I had time set time to be read by Application on times as 22:00
to fit it into the cell it was in.

Format Cells / Custom / h:mm

Which looks the same Format as 24hr but smaller

But for Application on times to read the Time Format when being Called by another Macro

it needs tot be set as 22:22:00

Format Cells / Time / 13:30:55 (4th one down)

Still don't know why it still worked every time 100's of times when actually clicking macro directly containing Application on times talk about misleading ?????

Sheet attached, i was prepping for Forum for testing, as i said i would, but figured it out while doing that and post by

westconn1-Pete VB Forums saying he did it and "i would suspect the timevalue from cell may not give the required result"

So Cheers Pete you da man : )

So simple but not to the novice "Me" : )

Never give up : )

Mike