Excel VBA SSH SCP Help

[kdwdillson]

Have workbook with 2 worksheets. worksheet 1 has server info & worksheet 2 has different user ID & passwords. Seeking VBA code to make this happen, please. Thank you!

using putty & winscp: c:\temp\putty\putty.exe & c:\temp\winscp\winscp.exe

Need excel to launch either putty or winscp session (ssh or scp) when clicking on either ssh or scp. When click on either ssh or scp, it should use user ID & password from worksheet 2. Lets say password is Test123 and connect to corresponding server.
See table as guide.

Env	Server	Protocol	Protocol
Prod	server1.acme.com	ssh	scp
Test	server2.acme.com	ssh	scp
Dev	server3.acme.com	ssh	scp

<tbody>
</tbody>

 

[kdwdillson]

let's say a user id is user1, user2...