| View previous topic :: View next topic |
| Author |
Message |
rxlane
Joined: 18 Jan 2007 Posts: 5
|
Posted: Wed Jan 31, 2007 1:23 pm Post subject: Monitoring a file after an Excel Task |
|
|
I having a problem running a taskchain with a task opening up an excel file running a fully automatic excel macro saving it and exiting, but after that I want to copy this file from a local drive to a share drive in the network, my problem is that when I run the excel task, it immediately runs the a monitoring task for a file change, so I what need some type of waiting time for the excel macro to finish, how can I do this ? ? |
|
| Back to top |
|
 |
rxlane
Joined: 18 Jan 2007 Posts: 5
|
Posted: Thu Feb 01, 2007 7:06 am Post subject: |
|
|
| Does some one in the forum has a sugestion on what can I do |
|
| Back to top |
|
 |
Robert Site Admin
Joined: 25 May 2006 Posts: 1140
|
Posted: Thu Feb 01, 2007 7:58 am Post subject: |
|
|
The excel task runs and returns immediately. You will have to run a delay task (tasks menu / misc menu) between your excel and monitor task in a chain.
also, There is a way to automatically stop the excel macro within Visual basic macro after x seconds. I will find and provide that link |
|
| Back to top |
|
 |
|