FTP & Application.Wait 1

[bmoremu]

I have the following line to run an FTP script which transfers a file to a remote server and records the log in 'FTPoutput':

Shell "cmd /c ftp -s:" & FTPscript & " > " & FTPoutput

I want a msgbox to pop up after the transfer completes indicating that it was successful. Right now I have:

Application.Wait Now + TimeValue("00:00:25&quot

Then I search for the line in the log that starts with "250" indicating a successful transfer. However, the file transfer varies from 10 - 35 seconds, so is there a way I can wait for the command shell to close before searching the log??

 

[zarkon4]

check the following link for an example of shelling and waiting

http://www.vbaccelerator.com/home/V...it_For_Completion/ShellWait_Demonstration.asp

 

[PHV]

If you have WSH installed, you can try this:

Set Sh = CreateObject("WScript.Shell")
cmd = "cmd /c ftp -s:" & FTPscript & " > " & FTPoutput
ReturnCode = Sh.Run(cmd, 1, True)

Hope This Help
PH.