SFTP and VBA

[lala]

Hi
is there any way to upload a file to a folder already created on an sftp site by using VBA?
i have code (complicated, and a library db to come with it if anyone needs) to do it to an ftp site, but not sftp

thank you

 

[The_Doc_Man]

Some versions of SFTP allow you to specify a "command" procedure. I would shell out to a DOS-like prompt and tell SFTP to connect to the site and execute a canned procedure. If you wanted to get fancy, build the procedure before you execute it.

 

[lala]

i could never write anything like that myself, at least, not in the near future

i was hoping that someone has some code that i can use, same way i was able to for FTP, but wasn't able to fins anything online yet

 

[DJkarl]

http://winscp.net/eng/index.php is FreeWare and I believe allows command line procedures. They have some example scripts I believe.

 

[lala]

Thank you so much, I will check it out as soon as I get to work