• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to download the file from Filezilla through vba code.(SFTP)

I've no idea about Filezilla. But you can use WinSCP for SFTP download automation.

If you go to WinSCP site they give example code. Though it's in VBS you can easily adopt it to VBA.
https://winscp.net/eng/docs/library_session_getfiles#vbscript

Or you could use Shell() function instead to download files using WinSCP. For shell example, just do search on google and you'll find plenty of examples.

But if you want to just automate/script download from SFTP. Why not just use CURL?
 
hi thank you for your response .ok i will try Winscp.

But Now i have SFTP (Filezilla) Application only. i was explore in google but still i did't get the answer.
if you have any idea please let me know.
 
hi thank you for your response .Now i instal the winscp. how to download the file from winscp(SFTP) through Excel VBA
 
You must log in or register to reply here.
Back
Top