Auto Upload

Advertisement

Schursch
Joined:
Posts:
1
Location:
Frankfurt am Main (Germany)

Auto Upload

Hi all,

I am using WINSCP 3.6.8. and I want to upload an Excel-File by VBA automatically.


... Shell("C:\Program Files\WinSCP3\WinSCP3.exe upload@prod.gb.users.com /upload C:\test_file.xls /home/uploads/)")

It works fine until the message-box (Copy) appears where I have to confirm it manually.

It would be nice if someone knows how to disable the message box or how to change the command.

Thanks in advance and kind regards,

Schursch

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
27,253
Location:
Prague, Czechia

Re: Auto Upload

Use /defaults or use scripting. In any case, you need to upgrade.
_________________
Martin Prikryl

Reply with quote

Highage
Guest

I am attempting this too

here is part of my code:

Print #lInt_FreeFile01, "option batch on"
Print #lInt_FreeFile01, "option confirm off"
Print #lInt_FreeFile01, "open xxx.xxx.edu"
Print #lInt_FreeFile01, "xxxx"
Print #lInt_FreeFile01, "xxxx"
Print #lInt_FreeFile01, "cd public_html/"
Print #lInt_FreeFile01, "option transfer binary"
Print #lInt_FreeFile01, "put " & ThisWorkbook.Path & "\jw\test1.txt"

but still search on ...

Reply with quote

martin
Site Admin
martin avatar
Joined:
Posts:
27,253
Location:
Prague, Czechia

Re: I am attempting this too

Highage wrote:

here is part of my code:

...

but still search on ...
And what problem do you have?
_________________
Martin Prikryl

Reply with quote

Highage
Joined:
Posts:
1
Location:
MO

I figured out. Thanks Admin.

I tested back and forth and figured out. I used windows FTP command to set up a VBA module to do auto FTP a few days ago. But later on I realized I need to do SFTP so I find out Winscp. But the script has to be changed.

The change is primarily:

...shell(...winscp.com /script=script.txt)

and open user:password@sftp.com is also structurally different from my previous script.

Now it is working on my side and I need to do test with SFTP account of real customers.

Reply with quote

Advertisement

You can post new topics in this forum