Downloading file from SFTP

Hey guys,

My objective is to find a way to populate a model on excel by extracting specific raw data which exists in an SFTP server. I found a macro template here which has really helped tie in a big part of this task, here: http://www.excely.com/template/ssh-client.shtml (download of the template available at the bottom of the page).

By inputting the information required for connecting to the STFP, I can click the "download file" and VBA will launch my SFTP client, WinSCP, and open the folder I specify. BUT, it does not actually open the file or locate it, it just does not make that final step.

Looking through the private code by clicking 'view source' on the tab, I can see all the macro codes, but I am not sure what should be modified. I see that it is calling a 'Shell', but I fail to see any pre-defined Shell function. My guess is that it is somehow calling a text file which in turn gets run via command-line somehow, but this is not visible within the code.

I realize this may be ambiguous if unable to try on my specific server, but any information or guidance is greatly appreciated.

This one's a toughie, I thank any help in advance!

Paul

Hi Paul - I see no one has responded to this. I am following the same steps you have used and have run into the same problem. Did you every figure out what to do with the "Shell"?

Thanks,
Peter

I have not tried the code, nor do I have access to SFTP sever. This is just to give you some pointers, but it might not make sense or work. If you managed to access the page, you need to find where the file you want to down is located within a page. I think the code just gives you how to access a site, but unlikely to pin point where the file is located The template may have a file extension which gives you what kind of file it is. It is mostly likely going to be a pdf, xls or cvs files.