Downloading SFTP files in Excel using Win SCP?

[vpan16]

We had a script that took all the FTP files (.csv formatted) from a report directory matching the times a user inputted and opened them in excel.

But all of our logins have moved from FTP to SFTP.

Now my understanding is, with SFTP we cannot simply go to teh internet, we would need to extract data from an SFTP client.
I heard that WinSCP can do this seamlessly.

I've followed the protocol to get the winscp assembly/library as a reference in my developer tools.

I just dont really understand the coding and syntax itself.
My WinSCP.exe file is not in the same directory as the .dll file and so I get an error say the winscp.exe executable was not found at location of the assembly, nor in any installation path. You may use Session.ExecutablePath property to explicitly set path to winscp.exe.

Now I have no idea how that works, ive tried everything but looks like there is no variable type as Session?

Not sure how to proceed. Has anyone successfully used VBA to download SFTP files into excel and would be willing to share their codes (without the SFTP credentials of course)


The code I am currently using is modified from this one right here: https://winscp.net/eng/docs/library_vb#example

 

[RedBeard]

This might be of help: https://social.msdn.microsoft.com/F...file-from-sftp-site-using-vba?forum=accessdev