winscp FTP put dose not work

starlev

New Member
Joined
Feb 21, 2016
Messages
27
I'm trying to build a macro that builds bat files from VBA and then runs the file.

The purpose of the bat file is to connect to download the file from a FTP

I am using winscp to connect and download files

I have the following code that works great for downloading files from a "sftp"

winscp.com /command "open sftp://name:Pasword@host:Port" "get garfieldand5.png ""D:\cmd invetory\""" "exit"



However when I try to download not from secured ftp

for example the code that I'm using is



winscp.com /command "open ftp://name:Pasword@host" "get /Inventory/Inbound/Jet.csv ""D:\cmd invetory\""" "exit"



It is not working properly and I get an error that



Unknown command "get /Inventory/Inbound/Jet.csv ""D:\cmd invetory\""" "exit"





When I just put in the following line winscp.com /command "open ftp://name:Pasword@host"

I am able to connect properly to the FTP the issue starts when I tried to download a file with the "get" method.





What am I doing wrong?
 
Last edited by a moderator:

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Hard to tell. It is all about building up the command line in the right way, with the spaces and (the amount of) quotation marks on the right place, so your program (winscp) is able to interpret the expected arguments in the right way.
Btw would you please leave out any unnecessary blank lines for a possible next post? It reads a bit easier.
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,324
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top