WINSCP SFTP transfert issue with a Put command

Pat35
Joined:: 2020-01-16
Posts:: 1
Location:: Rennes

WINSCP SFTP transfert issue with a Put command

2020-01-16 18:05

Hello
i wrote the script below in Outlook VBA :

Call Shell( _
"C:\Program Files (x86)\WinSCP\WinSCP.com  /command " & _
"""open ftpes://customer:password@ftpclients.com/ -timeout=5 -certificate=xxxxxxx -rawsettings ProxyPort=0""" & _
"""put C:\Users\sent_FTP\testfile.csv""" & _
"""exit""")
End Sub

when i executes the script, i see in a CMD windows that the remote FTP server is open but the file is not transfered
the command visible in window is : winscp >
if i copy past the command "put C:\Users\sent_FTP\testfile.csv" in CMD windows, that is working very well, the file is transfered

i don't understand why the script doesn't execute the command "put" automatically

regards

Pat

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 40,605
Location:: Prague, Czechia

Re: WINSCP SFTP transfert issue with a Put command

2020-01-17

You are missing some quotes and spaces:

Call Shell( _
"""C:\Program Files (x86)\WinSCP\WinSCP.com""  /command " & _
"""open ftpes://... ..."" " & _
"""put C:\Users\sent_FTP\testfile.csv"" " & _
"""exit""")
End Sub

See https://winscp.net/eng/docs/commandline#syntax

Reply with quote

You can post new topics in this forum

WINSCP SFTP transfert issue with a Put command

WINSCP SFTP transfert issue with a Put command

Re: WINSCP SFTP transfert issue with a Put command

Documentation

Support

Associations

Follow Us