Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am having trouble with Application.OnTime when specifying a Macro
with Numeric (Byte) parameter. Here is the code: macro I'm calling: Public Sub mcrExtractIntraData(bteIntraday As Byte) Failed attempts: 1) NextIntradayTime = Now + TimeValue("00:01:00") strProc = "mcrExtractIntraData" & " 1" Application.OnTime NextIntradayTime, strProc 2) NextIntradayTime = Now + TimeValue("00:01:00") Application.OnTime NextIntradayTime, "mcrExtractIntraData " & 1 3) NextIntradayTime = Now + TimeValue("00:01:00") Application.OnTime NextIntradayTime, "'mcrExtractIntraData 1'" Any help greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pass date parameter into MS Query | Excel Discussion (Misc queries) | |||
Is it possible to pass a parameter into IN operator in Query? | Excel Discussion (Misc queries) | |||
How to pass a workshhet name as a parameter into a subroutine ? | Excel Discussion (Misc queries) | |||
Pass Parameter to Access Query | Excel Programming | |||
unable to close macro using auto_close or application.quit | Excel Programming |