Help with Application.OnTime

Hi,

I am writing an Excel macro that has a sequence of 5 tasks to complete.
Each task is completed by saving a file. Now, I want the processing for
the second task to start only after the first task's output file has
been saved.

' Task 1
::::
::::
Application.OnTime Now + TimeValue("00:10:00"), SrcFlPath + DataFlName
+ "!Module1.SaveFile"

' Task 2
:::::::::
::::::::
where the SaveFile subroutine saves an output file in the target
location and closes the output file for each task.

Currently, since the file is saved after 10 minutes time, the second
task's processing starts without waiting for the output file to be
saved and the first task completed. How can I ensure that the second
task starts only after first task's file has been saved?

Thanks.

Have SaveFile call Task2 and so on.

--
Regards,
Tom Ogilvy



"[email protected]" wrote:

> Hi,
>
> I am writing an Excel macro that has a sequence of 5 tasks to complete.
> Each task is completed by saving a file. Now, I want the processing for
> the second task to start only after the first task's output file has
> been saved.
>
> ' Task 1
> ::::
> ::::
> Application.OnTime Now + TimeValue("00:10:00"), SrcFlPath + DataFlName
> + "!Module1.SaveFile"
>
> ' Task 2
> :::::::::
> ::::::::
> where the SaveFile subroutine saves an output file in the target
> location and closes the output file for each task.
>
> Currently, since the file is saved after 10 minutes time, the second
> task's processing starts without waiting for the output file to be
> saved and the first task completed. How can I ensure that the second
> task starts only after first task's file has been saved?
>
> Thanks.
>
>