FTP within VBA
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