My problem is this...


Since the

SHELL() availiable in VBA is asynchronus.


WHAT MY CODE IS DOING
--------------------------------
Actually a batch file is called through the Shell which in turn runs a
rsh on the unix machine and brings the file using the GET command.

Since it is diificult to predetermine the time taken to FTP ,in some
cases of file transfer the TEN SECONDS pause that I use in code is
exceeding thus causing trouble.

How to get around this problem???


.. Also I was thinking in the following direction to get around..


When we call SHELL(...) it returns a TASK ID assigned by the PC .Is
there a way to get the status of this TASK ID so that it can be
utilised to trigger the next line of the code ... instead of the timer
approach that I am currently using...


Thanks



---
Message posted from http://www.ExcelForum.com/