Excel VBA Shell FTP Logging

Question

So I have code that creates a sequence of steps in a text file in the temp directory and then executes the shell FTP. The question I have is, once the shell is launched and is running through the FTP, is it possible to log the FTP results? Like if a file failed to upload or "can't find file name" etc? This way I can be away from the computer while the script is pushing files to the FTP and later look at the log to see what failed and why.

This is my FTP launch command:

Sub executeFTPBatch(ByVal ftpfileName)
    Dim wsh As Object
    Set wsh = VBA.CreateObject("WScript.Shell")
    wsh.Run "FTP -i -s:C:\Temp\" & ftpfileName & ".txt", 1, True
End Sub

Try monitoring to output of the Run command: result = wsh.Run(... then If result<>0 Then MsgBox "Error: " & result — paul bica
– paul bica, Commented Sep 17, 2015 at 0:28

Martin Prikryl · Accepted Answer · 2018-02-14 07:08:43Z

3

Redirect the output of the ftp.exe to a file:

wsh.Run "%comspec% /c FTP  -i -s:C:\Temp\" & ftpfileName & ".txt > c:\path\ftp.log 2>&1", 1, True

See also https://ss64.com/nt/syntax-redirection.html

edited Feb 14, 2018 at 7:08

answered Sep 17, 2015 at 6:05

Martin Prikryl

205k64 gold badges560 silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Snoobie Over a year ago

This worked perfectly. Thank you so much for teaching me this!

Collectives™ on Stack Overflow

Excel VBA Shell FTP Logging

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related