I am trying to run a shell routine within Access VBA, to FTP download a file.
However the code that follows the shell command tries to read this new file but the download hasn't been completed.

Desirably, I would like to create a wait event until the shell is closed,
or failing this just create a delay of a fixed amount of secs.

the code is:

RetValue = Shell("c:\Program Files\WS_FTP Pro\ftpscrpt.exe -f c:\Data\script1.scp")


Thanks in advance Ray

__________________
Cheers Ray

http://www.mvps.org/access/api/api0004.htm

Ciao
Jürgen Welz
Edmonton AB Canada
[email protected]

Thanks Jurgen - Great. Didn't realise it was so involved.

Cheers Ray

How about capturing the file size of file to be downloaded before downloading?

After the FTP download command, create a Wait Loop that just loops checking filesize until it equals the initial value captured. When the downloaded file size matches, then you continue with the rest of the code.